| - 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 |
DB/__Oracle