Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cluster removal
In article <3d83bd70.0303310123.7ffba25c_at_posting.google.com>,
anaskhan_at_bns-solutions.com says...
>
>Hello there
>
>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
Oh, and one thing I forgot. You can NEVER remove all the clusters from a database. There are some in the data dictionary.
HTH. Additions and corrections welcome.
Pete
SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Mon Mar 31 2003 - 10:35:10 CST