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: SQL*Plus 'copy' cmd: deal with rollbacks ?

Re: SQL*Plus 'copy' cmd: deal with rollbacks ?

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 21 Dec 2005 10:51:11 -0800
Message-ID: <1135191055.437349@jetspin.drizzle.com>


Spendius wrote:
> Hi,
> I'm afraid there's no way to really address rollback segment
> management when you use the COPY command of SQL*Plus,
> or I'm mistaken ?
>
> You can deal with the amount of records copied before regularly
> committing when playing with ARRAYSIZE and COPYCOMMIT
> values, but can you *assign* a particular rollback to your remote
> before-image and a particular rollback on your destination DB
> each time you've committed (without having to create a huge
> rbs on each DB and off-lining the other regular undo segments) ?
>
> I'd like to be able to manage my rollbacks use on both my source
> and destination DB's as easily as you can with the SET TRANSACTION
> USE ROLLBACK... instruction, but that does not seem possible...
>
> Thanks a lot.

What version of Oracle?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Dec 21 2005 - 12:51:11 CST

Original text of this message

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