| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
