Re: about clusters...

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Thu, 14 Jan 1999 07:46:19 -0500
Message-ID: <369de743.0@news.mountain.net>

The only way is:
1) to cluster a non-clustered table you need to first create the cluster, then do a create table new_table cluster my_cluster as select * from old_table;

2) to un-cluster a table the statement is create table new_table as select * from old table;

Kenny Gump
OCP 7.3 DBA

---

jayvee_at_mayon.cats.edu.ph wrote in message <77jg3j$qem$1_at_nnrp1.dejanews.com>...
>Dbies,
>
>Is it possible for a non-clustered tables to be clustered and
>for a a clustered tables to be made non-clustered.
>
>Thank you.
>
>(please respond by e-mail)
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Jan 14 1999 - 06:46:19 CST