how to move a table from one tablespace to another

[amits]

How to move a table from one tablespace to another ?
Thanks

[noor]

Hello,

If you are using Oracle 8i/9i you can use the following sql-stmt

ALTER TABLE table_name
MOVE TABLESPACE tablespace_name;

If you Oracle version is 7/8, you can :

- Copie you table to your new TS :

CREATE TABLE new_table_name AS SELECT *
FROM old_table_name;

- Drop the old table (tabke care of dependencies !!!).

- Rename the new table ....

Hope this helps

[oddster]

..... remember that this is only available in the Enterprise version of Oracle!

Good luck!

[oddster]

......that is the 'ALTER table MOVE' command.