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:
> 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
![]() |
![]() |