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>


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

Original text of this message