Home » RDBMS Server » Server Administration » Altering tables whithin clusters.
Altering tables whithin clusters. [message #370202] Fri, 30 October 1998 05:00
Richard Chinn
Messages: 1
Registered: October 1998
Junior Member
I have inherited an Oracle 7 database which makes use of clustering.

I need to make some alterations to clustered base tables. As far as I can tell, the best way to do this is by:

1) Copy tables to a new tablename ie
'create table table_name2 as
select * from table_name1'

2) Make alterations to newly ceated table.

3) Drop old tables and clusters.

4) Create a new cluster.

5) Create new table ie:
'create table table_name1 as
select * from table_name2
cluster field_name (name)'

Is this the best way around this problem?

How can I find out which fields are contained in which clusters. I guess I'll need to find that out before I can create my new tables.

Thanks for any suggestions in advance.

Richard C
Previous Topic: Error message
Next Topic: New ORACLE discussion board
Goto Forum:

Current Time: Sun Nov 27 19:21:03 CST 2022