Re: Drop a cluster but keep the tables - how?
From: Oracle System Account <oracle_at_coulomb.pcc.oz.au>
Date: Sun, 18 Apr 93 22:23:17 GMT
Message-ID: <1993Apr18.222317.12576_at_coulomb.pcc.oz.au>
Date: Sun, 18 Apr 93 22:23:17 GMT
Message-ID: <1993Apr18.222317.12576_at_coulomb.pcc.oz.au>
Chris,
The easiest way to do your job, I believe, is as following:
1 Find the table creation script (must be somewhere!);
2 Do a table export that contains all the tables in that cluster you wish to drop; 3 Drop tables and cluster; 4 Use the script to create those tables (of course no cluster!); 5 Do entire import from that export file.
Regards,
Peng Hu hu_at_coulomb.pcc.oz.au
Oracle DBA
Prospect Electrict
Sydney, Australia
Received on Mon Apr 19 1993 - 00:23:17 CEST