Oracle

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 …

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 …