Materialized View -Fast Refresh
DBARepublic.com • 10:22 AM
Have you worked with View before? Yes, I mean just a View not a Materialized View. Let’s refresh the concept of View before learning about ...Read More
Results for >>:::
Oracle Database
Table Partitioning 101
DBARepublic.com • 8:54 AM
Oracle Table partition uses an old concept of divide-and-conquer strategy where a large table is divided into smaller tables based on part...Read More
Finding Index Fragmentation
DBARepublic.com • 8:56 AM
Index Fragmentation is defined as a condition where more than optimal amount of disk I/O is performed when accessing a table. In a simple...Read More
DBMS_REDEFINATION Package
DBARepublic.com • 8:08 AM
The data inside a table grows with time if you don't set up proper purging process. Sometime a business requires all data and may not...Read More
LISTAGG Exception
DBARepublic.com • 8:45 AM
Based on Oracle, LISTAGG orders data with each group specified in the ORDER BY clause and then concatenates the values of the measure colu...Read More
Enable Row Movement
DBARepublic.com • 9:25 PM
"Updating partition key column would cause a partition change" is an Oracle error message. Oracle logs it as ORA-14402. This is...Read More
WITH GRANT OPTION
DBARepublic.com • 8:41 PM
GRANT lets you grant SYSTEM and OBJECT privileges to users and roles. This is a very powerful feature which should be used with very cautio...Read More
WITH Clause
DBARepublic.com • 12:49 PM
WITH CLAUSE also known as sub-query factoring clause, It allows you to give a name to a select query and use the result inside a query. WIT...Read More
Finding Duplicate Records
DBARepublic.com • 5:44 PM
How to find out duplicate records from a table? Read this question again? How to check for duplicates records from a table? Ok, the fir...Read More
The ONLINE Keyword for Create Index
DBARepublic.com • 8:33 AM
Most Database Management Systems including Oracle locks the table completely for reads and writes when performing Data Definition Language (...Read More
Synonym: Why do you need it?
DBARepublic.com • 6:51 AM
This is a frequently asked question by developers and novice database administrator. Why do we need a synonym when I own the database object...Read More
Global Temporary Table (GTT)
DBARepublic.com • 3:05 AM
Global Temporary Table is also known as GTT. The global table is not much different than regular table you create with any database with few...Read More
Subscribe to:
Posts
(
Atom
)
