Export Import Utility
DBARepublic.com • 9:20 AM
Who remembers the Export-Import definition from grade school? According to Investopedia, Export is a function of international trade whereby...Read More
Results for >>:::
Oracle Database
How Complete Refreshable Materialized View Works?
DBARepublic.com • 3:53 PM
This article is inspired by a question repeatedly asked to me: Why do you use a Complete Materialized View and not a Table or just a View? W...Read More
Questions Oracle DBA Asks
DBARepublic.com • 8:49 PM
This is not about Angry Bird? It is about ANGRY DBA? Want to make them happy and get your job done? Whenever you are working on a issue that...Read More
Read Only Table
DBARepublic.com • 10:00 PM
Ready only table, what the heck is ready only table? Well, it is self explanatory by it's name. This table type allows user to SELECT bu...Read More
Dropping Column
DBARepublic.com • 10:23 AM
You all have dropped or added a column to an employee table. How long does that take? couple seconds, or may be milli-seconds. ALTER is DDL ...Read More
Tuning A Query Using Database Link:
DBARepublic.com • 9:51 PM
A query that uses a table from remote database is taking a while to process and we will tune that slow query to make it faster. There is no ...Read More
Switching to a Different Schema
DBARepublic.com • 10:27 PM
Who remembers to their first week as DBA or Developer? I do, my very first week as an Application Database Administrator Job, I was assigned...Read More
RowId Vs Index
DBARepublic.com • 9:18 PM
and the winner is dbarepublic... I am kidding right? With this article, we will find out who is the real champion among INDEX and ROWID? M...Read More
Renaming Object
DBARepublic.com • 9:02 PM
As the title states, it just re-name from old object name to a new object name. Not all Oracle objects can be re-named easily. Oracle Table,...Read More
Foreign Key Index Check
DBARepublic.com • 11:11 AM
What is a Foreign Key? It is a point in one table that links to a Primary Key(PK) of another table. The relationship between these tables ...Read More
Grouping Records By...
DBARepublic.com • 10:07 PM
Did you know? SQL is a great query language for writing reports. A report include numbers, days, dates, times, events, counts etc.By combini...Read More
Slow DELETE
DBARepublic.com • 10:38 PM
No one gets a maintenance window for days. The standard maintenance window is 4 hours or less for most companies. There are however applica...Read More
TNSPING Utility
DBARepublic.com • 12:02 PM
TNSPING is an Oracle utility to determine if the listener for a service on an oracle network can be reached successfully. This utility is lo...Read More
Locking The Result Set
DBARepublic.com • 1:18 PM
In a busy organization, where the applications are pulling, updating, purging records, we need to be really careful when doing a maintenance...Read More
IN vs EXISTS
DBARepublic.com • 10:00 AM
You all may have used IN, NOT IN, EXISTS, and NOT EXISTS or have seen at one point in their IT career. Many believe SQL keyword IN is simila...Read More
Integrity Constraints Management.
DBARepublic.com • 10:00 AM
A wise man once said: "Data must protect itself!". This is exactly what database constraints do. A rule that restricts the values ...Read More
Alternative to LISTAGG Function
DBARepublic.com • 10:00 AM
Based on Oracle, LISTAGG orders data with each group specified in the ORDER BY clause and then concatenates the values of the measure column...Read More
Why V$DATABASE is NOT playing Nice?
DBARepublic.com • 10:00 AM
Mr JG recently graduated from his internship program and the company hired him as Oracle Developer. He is excited and working hard on his f...Read More
Subscribe to:
Posts
(
Atom
)
