How to Create Reference Partitioning in Oracle 11g (Example)
The TEST1 table will be the parent and therefore must be created as a partitioned table.And table TEST_TAB will be the …
The TEST1 table will be the parent and therefore must be created as a partitioned table.And table TEST_TAB will be the …
Oracle ASM Configuration Assistant (ASMCA) was introduced in Oracle ASM version 11.2. ASMCA supports installing and …
Reference partitioning provides the ability to partition a table based on the partitioning scheme of the table …
Composite Data Types You learned that variables of the scalar data type can hold only one value, whereas variables of …
This post explains 11gR2 and 12cR1 Grid Infrastructure configuration framework config.sh(config.bat on Windows) which is …
Hint Usage Report is a new feature from 19c which helps to determine from the execution plan output which are all the …
Beginning with Oracle10G, when statistics are gathered for a table, the old statistics are retained so should there be …
Question: How to find the log files for OPatch and OUI ( Oracle Universal Installer)? OPatch (Common for Windows and …
This script shows which tables and indexes are either missing statistics or have stale statistics, and the statistics …
This is a small note for the new features introduced in Oracle 11g related to Relinking. Methods of Relinking Oracle …
Open Database Connectivity (ODBC) provides a standard interface that allows application access to many different …