| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: For what is the DEF$_TEMP$LOB table used?
Bryan
I plugged that table name into Google and received 87 hits. I don't have time to research this, but if you don't get a good reply to your posting you may want to give Google a try.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, April 24, 2003 10:27 AM
To: Multiple recipients of list ORACLE-L
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).
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 - 11:06:51 CDT
 |
 |