RE: Oracle 8i database reorg

  • From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 13 May 2004 11:01:56 -0500

Aaron
   Take a look at dbms_space_admin.tablespace_migrate_to_local. I haven't
used it, but some on this list have had good success. It may be just the
ticket for you. 

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Aaron Sentell
Sent: Thursday, May 13, 2004 10:06 AM
To: Oracle-L@xxxxxxxxxxxxx
Subject: Oracle 8i database reorg


I have a 30 GB Oracle 8.1.7 database that I would like to reorg and at the
same time modify to use locally managed tablespaces. This is the first time
I will be attempting something like this. Database downtime is not a big
issue, but I still want to do it as quickly and efficiently as possible.
I've read a 1999 technical document from the IOUG web site that describes
how to do this using export/import, but I was wondering if anyone has any
other methodologies that they prefer? BTW, I need the tablespace names to
remain the same.

Thanks,
Aaron


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: