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: Fri, 23 Dec 2005 09:28:10 -0800
Message-ID: <1135358872.346052@jetspin.drizzle.com>


Spendius wrote:
> You're right. This instruction does not work in automatic undo segment
> mode.
> I either get "ORA-00911: invalid character" when I put the name of an
> undo
> segment (that starts with an underscore '_') or "ORA-30019: Illegal
> rollback
> Segment operation in Automatic Undo mode" when I try with the... SYSTEM
> segment.
> Anyway the problem I encounter with the COPY cmd of SQL*Plus is related
> to 2 8i databases.
> Thanks.

Then post the relevant information and, again, why are you trying to do this with the copy command? How much data? How many schemas? How many tablespaces and data files? etc.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Dec 23 2005 - 11:28:10 CST

Original text of this message

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