You can disable archiving, you can specify that the load is UNRECOVERABLE,
or you can set the NOLOG attribute of the objects being loaded.
--Kevin
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, June 18, 2001 5:50 PM
To: Multiple recipients of list ORACLE-L
Hello,
I have a sql*loa
Philippe,
If you have a large rollback segment that you want to use for a particular operation
you can use the "SET TRANSACTION USE ROLLBACK SEGMENT xxx" command to assign the use
of a rollback segment.
To make sure you are the only operation using it, set it "offline" first and wait for
the
and please check whether other user is doing any transaction in the
rollback segment.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 9:35 AM
To: Multiple recipients of list ORACLE-L
Phillipe:
Try setting the other rollback segments temporarily offli
Phillipe:
Try setting the other rollback segments temporarily offline so that
the loader only finds the big segment for use.
Regards
adm-unix@eram