Re: What is the logging column of the DBA

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Mon, 11 Jun 2001 12:47:39 -0700
Message-ID: <F001.003247A2.20010611122551@fatcity.com>

Gopal,
How about this:
1* select owner,table_name, logging from dba_tables where logging != 'YES' SQL> /

OWNER                          TABLE_NAME                     LOG
------------------------------ ------------------------------ ---
SYS                            ATEMPTAB$                      NO
SYSTEM                         DEF$_TEMP$LOB                  NO

This is 8.1.6.2 on HP-UNIX and value not set by us....

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Mon, 11 Jun 2001 11:45:40 -0800

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).

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.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 - 14:47:39 CDT

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