Oracle-L: For what is the DEF$_TEMP$LOB table used?

From: Rodrigues, Bryan <BRodrigues_at_elcom.com>
Date: Thu, 24 Apr 2003 07:26:38 -0800
Message-ID: <F001.0058869B.20030424072638@fatcity.com>

Hello,

I have created a standby database using 8.1.7.4 on HP-UX 11.0 and it is recovery mode. I was looking through the database for objects with no logging. I have found some temp tables (no problem, because the information in them is used in the session and then removed), but I also found the DEF$_TEMP$LOB table that is owned by system. I looked at the other 8.1.7.4 databases and they all have the same settings.

Can someone tell me the following:
what uses this table is used?
can I change the table to logging without hurting the system? should I change it to logging?

I would like to have all objects logging for the standby database, but could table have to be an exception?

Thanks,

Bryan Rodrigues
DBA
Elcom, Inc.

--

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

Author: Rodrigues, Bryan
INET: BRodrigues_at_elcom.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Thu Apr 24 2003 - 10:26:38 CDT