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 offline so that
the loader only finds the big segment for use.
Regards
adm-unix@eram
et-sln.nc To: Multiple recipients of list
ORACLE-L
Sent by: <[EMAIL PROTECTED]>
root@fatcity. cc:
com Subject: Sql*Loader and assign
a ROLLBACK
segment
19-Jun-2001
08:50 AM
Please
respond to
ORACLE-L
Sender Info:
No Sender
Info found in
the address
Book
Hello,
I have a sql*loader script which failed due to the non possibility to
extend a rollback segment in the
TBS ROLLBACK_DATA.
Oracle version 8.1.6.2 on AIX 4.3.3.
I have a huge rollback segment in the TBS ROLLBACK_DATA, but how tell to
sql*loader to use
this rollback segment ?
I have not found any option to assign a rollback segment in the doc.
I just found the UNRECOVERABLE option and i will try with it.
Any other ideas, suggestions welcome.
Best regards
Philippe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
____________________________________________________________________________
__________
Visit us at www.singaporeair.com.
____________________________________________________________________________
__________
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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: Raymond Lee Meng Hong
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).