Tablespace Rebuild Script?
Date: Tue, 15 Nov 94 00:53:03 -0500
Message-ID: <9411150553.AA00488_at_uu4.psi.com>
Hi There,
I need to rebuild one of my tablespaces.
As you may know, export has 3 levels: Full dbs, User, & Table.
So here's my plan:
write a sql script which SELECTs an export shell command for TABLE_NAME
FROM DBA_TABLES
So, I run this thing and end up with a bunch of export commands.
I run the commands and end up with a bunch of export files (one
for each table in the tablespace).
Next, I drop the tablespace and then recreate it.
Then, I import each of the table level export files.
So, anyone already do this? I'd hate to re-invent the wheel.
-Dan
WHERE TABLESPACE_NAME = 'the one I am rebuilding'
/
Daniel B. Bikle/Independent Oracle Consultant
dbikle_at_alumni.caltech.edu | 415/854-9542 | P.O. BOX 'd' MENLO PARK CA 94026
Received on Tue Nov 15 1994 - 06:53:03 CET