Oracle : Scheduling crontab to send EMAIL in Unix

Oracle : Scheduling crontab to send EMAIL in Unix $ vi test.bash

Crontab entry

  Updated Script.

    Crontab entry

   

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