Are the tables you are loading in direct mode in the same tablespace as your
other tables ?
If this is the case, then you will not be able to perform a complete
recovery on the tablespace
affecting the other logged tables. Whenever I have a mix like you have, some
logged and some not,
I keep the tables/indexes seperate. I hope this helps
-----Original Message-----
Sent: 10 May 2001 18:16
To: Multiple recipients of list ORACLE-L
DBAs,
I have two of my tables and index in nologging mode as I am loading data
using SQL*Loader direct path mode.
I have scheduled RMAN hot backup everday. When I issue REPORT UNRECOVERABLE,
I am getting both the Data and Index datafiles are unrecoverable.
I know that I wont be able to recover the tables in nologging mode. What I
would like to know is about the recovery possibility of other tables in
logging mode. Will there be any problem during recovery as these datafiles
are in unrecoverable status?
TIA
Cheers
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raj Gopalan
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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.com
--
Author: holders
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
