谁都知道在SQL*Plus中重命名(Rename)一个表的命令, 如下所示:
RENAME old_name TO new_name
ALTER TABLE old_name RENAME TO new_name
ALTER INDEX old_name RENAME TO new_name
RECOVER STANDBY DATABASE UNTIL ...
ALTER DATABASE RECOVER STANDBY DATABASE UNTIL ...
--备份表结构和数据
create table AAA_BAK as select * from AAA ;