Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Assigning sqlldr to a rollback segment

Re: Assigning sqlldr to a rollback segment

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Sat, 31 Oct 1998 21:33:59 GMT
Message-ID: <363b81de.2926444945@news.cyberus.ca>


I think you can assume he meant to say: take the small ones off-line....

tpall_at_bga.com (Thomas Pall) wrote:

>No you cannot. Not with Loader nor Import. The way you assign a
>rollback segment is to put online the small ones and put online the big
>one you need for Loader. Since it's the only one online, it will be used
>by Loader. Of course there are no other transactions going on, right?
>
>andrea_johnson_at_wolfe.net wrote:
>: Can I specify a specific rollback segment(s) for a SQL*Loader replace data
>: dump?
>
>: How?
>
>: (thanks!)
>
>: -----------== Posted via Deja News, The Discussion Network ==----------
>: http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>--

Robert Prendin
RP Data Solutions Inc.
Specializing in ORACLE DBA Support Services Received on Sat Oct 31 1998 - 15:33:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US