RE: For what is the DEF$_TEMP$LOB table used?

Thanks Arup,

This just confirms what I thought, but I wanted to make sure. The standby database is a 2 hour plane flight from work and I don't think my boss would've appreciated having to go there because of one table.

Bryan

-----Original Message-----
Sent: Thursday, April 24, 2003 3:17 PM
To: Multiple recipients of list ORACLE-L

Bryan,

The table is used in replication. Please note that leaving the logging status to NO does not mean that all the DML to the table will be disabled; only a certain DML is disabled, not all. Oracle manages the table and setting the status to nologging is done by it. It should be best left as such. There is no advantage to enable logging for this table.

For the standby database, this table is probably not important; otherwise Oracle would have kept the mode to logging, since it affects media recovery too.

HTH. Arup Nanda

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, April 24, 2003 11:26 AM

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.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).
-- 
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).