Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 Supplemental logging is not the default behaviour of the oracle database. It has to be enabled manually after the database is created. It can be enabled at two levels

  1.  DATABASE LEVEL
  2. TABLE LEVEL

...

No Format
bgColorCCC
SQL> SELECT supplemental_log_data_min MIN, 
supplemental_log_data_pk PK, 
supplemental_log_data_ui UI, 
supplemental_log_data_fk FK,
supplemental_log_data_all "ALL" 
FROM v$database;

...

Modifying supplemental log behaviour

...