Re: What is the logging column of the DBA_TABLES view used for?

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Mon, 11 Jun 2001 11:42:26 -0700
Message-ID: <F001.00324689.20010611114540@fatcity.com>

Hey !

You can not set the LOGGING value in the SYS tables. If is used to know whether the table is in LOGGING mode or NOLOGGING mode.

Normally NOLOGGING (or UNRECOVERABLE in older versions) is used to speedup certain operations (like CTAS/pCTAS or index rebuilds /data loads) and the not much redo is generated in thse cases.

However you need to take a complete backup once you take out from NOLOGGING Mode..

---

Have a nice day !!

---

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

---

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jun 11 2001 - 13:42:26 CDT