Enable or disable supplemental logging in Oracle

Enable or disable supplemental logging in Oracle

Check :

SELECT supplemental_log_data_min FROM v$database;

Enable :

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

Disable:

ALTER DATABASE DROP SUPPLEMENTAL LOG DATA;

Advertisements

One thought on “Enable or disable supplemental logging in Oracle

  1. FirstErik

    I have noticed you don’t monetize your website, don’t waste your
    traffic, you can earn additional cash every month because you’ve got hi quality content.
    If you want to know how to make extra bucks, search for:
    Mrdalekjd methods for $$$

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.