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

Home -> Community -> Mailing Lists -> Oracle-L -> import and rollback segments

import and rollback segments

From: Leonard, George <george.leonard_at_farnell.com>
Date: Fri, 20 Dec 2002 05:09:09 -0800
Message-ID: <F001.0051F7E6.20021220050909@fatcity.com>


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



George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)

Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:george.leonard_at_za.didata.com
Web: http://www.didata.co.za  

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).
Received on Fri Dec 20 2002 - 07:09:09 CST

Original text of this message

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