answer1:
ALTER TABLE old_table_name RENAME TO new_table_name;(大写为系统命令)
answer2:
SQL>SELECT tname FROM tab ;
TNAME
------------------------------
TEST
SQL> RENAME test TO temp ;
Table renamed.
SQL> SELECT tname FROM tab ;
TNAME
------------------------------
TEMP
rename只能修改自己schema下面的表。
answer3:
CREATE TABLE new_table_name AS SELECT * FROM old_table_name;
DROP TABLE old_table_name;
ALTER TABLE old_table_name RENAME TO new_table_name;(大写为系统命令)
answer2:
SQL>SELECT tname FROM tab ;
TNAME
------------------------------
TEST
SQL> RENAME test TO temp ;
Table renamed.
SQL> SELECT tname FROM tab ;
TNAME
------------------------------
TEMP
rename只能修改自己schema下面的表。
answer3:
CREATE TABLE new_table_name AS SELECT * FROM old_table_name;
DROP TABLE old_table_name;