Re: Sql*Loader and assign a ROLLBACK segment

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 other transactions to finish. then set it "online" and issue the "set transaction...." command with your function. then set it "offline" again while it is in use and no other operation will be able to use it. If you set it "offline" while it is in use the operation using it will continue until completed or inturrupted. ROR mª¿ªm

>>> adm-unix_at_eramet-sln.nc 06/18/01 08:50PM >>>

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: adm-unix_at_eramet-sln.nc 

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: 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.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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