DDL Wait Option in Oracle.

DDL Wait Option in Oracle. A DBA is trying to alter the table called SALES to add a column, TAX_CODE. he issues the following SQL statement:

But instead of getting something like “Table altered”, he gets:

The error message says it all: the… Read More

Fine-Grained Auditing (FGA)

Fine-Grained Auditing (FGA). Fine grained auditing extends Oracle standard auditing capabilities by allowing the user to audit actions based on user-defined predicates. It is independant of the AUDIT_TRAILparameter setting and all audit records are stored in the FGA_LOG$ table, rather than the AUD$ table. The following example illustrates how fine… Read More

SQL*Loader in Oracle 12c

SQL*Loader in Oracle 12c   SQL*Loader is a utility provided  by the Oracle to load the data into Oracle databases from various files like ascii files,textfiles,external files and csv files etc.., SQL*Loader provides two methods for loading data: conventional path load direct path load CONVENTIONAL… Read More