| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: import and rollback segments
If you cannot take the small ones offline, I do not think you can force to
use a particular RBS.
You could possible create multiple large RBS then take smaller ones offline
then import. After completion put smaller ones online.
You can try commit=y to commit after each buffer instead of each object.
Use a larger BUFFER size on import to reduce round trips to
export file.
Perhaps others have some tricks
Rick
"Leonard, George"
<george.leonard_at_fa To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
rnell.com> cc:
Sent by: Subject: import and rollback segments
root_at_fatcity.com
12/20/2002 08:09
AM
Please respond to
ORACLE-L
Hi all
Can a person somehow force a import process to use a specific rollback segment. I got a live system with many smallish segments, the dump file is about 20 GB and take just over 12 hours to process but it requires a big rollback segment.
I don't want to offline the small once so that only a big one is online since this causes problems with the day to day operation of the client systems.
Ideas.
George
You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: george.leonard_at_farnell.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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-LReceived on Fri Dec 20 2002 - 10:04:49 CST
(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.net -- Author: INET: Rick_Cale_at_teamhealth.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
 |
 |