Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: import and rollback segments
I am going with the commit=y it seems the best option since I am already
using buffer size.
This way I don't need to do anything with my current rollbacks.
Thx for the feedback
PS: can not remember now who it is but someone on this group wrote a new rman backup recover manual, can someone pls forward me the title of the book, someone asked me for it, know if I go to borders will find it just can not remember at the moment,
Thx all, have a good weekend.
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!
-----Original Message-----
Sent: 20 December 2002 14:54 PM
To: Multiple recipients of list ORACLE-L
You can not specify RB segment for import to use.
Consider using commit=y option of the import command.
-----Original Message-----
Sent: Friday, December 20, 2002 7:09 AM
To: Multiple recipients of list 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-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.net
--
Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.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).
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). Received on Fri Dec 20 2002 - 10:16:00 CST
![]() |
![]() |