- TABLE rename tips

- TABLE rename tips



you can copy a table using CREATE TABLE .. AS SELECT statement.

(but it DOESN'T COPY table key, index, column default)

After that, use DROP TABLE.



CREATE TABLE new_table AS SELECT * FROM old_table;

DROP TABLE old_table;



http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_73a.htm#2062898



Especially Oracle 9i supports RENAME TO clause.



ALTER TABLE old_table RENAME TO new_table;



http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_32a.htm#2086662