Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus 'copy' cmd: deal with rollbacks ?
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