| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle 8i database reorg
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_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Aaron Sentell
Sent: Thursday, May 13, 2004 10:06 AM
To: Oracle-L_at_freelists.org
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |