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

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 22 Dec 2005 18:33:10 +0000
Message-ID: <crrlq1p1hua7554qj3c2u1equri54ml1ns@4ax.com>

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.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Thu Dec 22 2005 - 12:33:10 CST