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

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 22 Dec 2005 13:44:51 -0800
Message-ID: <1135287875.450507@jetspin.drizzle.com>

Andy Hassall wrote:

> On Thu, 22 Dec 2005 09:18:29 -0800, DA Morgan <damorgan_at_psoug.org> wrote:
>
>

>>Rollback segments don't exist in 10g

>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> create rollback segment rbs1;
>
> Rollback segment created
>
>

>>and should not exist in a well configured system using 9i.

>
>
> No argument there, and it applies even more so to 10g, but rollback segments
> are still there in 10g "for compatibility with earlier versions of Oracle
> Database", to quote the manual.

If you manually create them: Otherwise they will not exist.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu Dec 22 2005 - 15:44:51 CST