Hello DBA's

In our database 10 tables use cluster storage.
There are 3 clusters and all the tables contain lots of records.
More than 20 foreign keys referencing tables in clusters.


How can I move all tables from Clusters to nomal tablespace without
affecting data loss or constraints.

Our aim is to remove all the clusters from database.

Will the export import help?

Hope somebody have prevoius experience on this.

Oracle version is 9.2.-.-



Anas Khan .S





B N S Solutions Pvt. Ltd.

E-mail: [Email Address Removed] <mailto:[Email Address Removed]


Oracle LazyDBA home page