oracle:表重命名
SQL> rename test1 to test;
Table renamed.
SQL> alter table test rename to test1;
Table altered.
两个方法亲测都ok
内容大部分引用王良明、赖国明著作,敬谢!
SQL> rename test1 to test;
Table renamed.
SQL> alter table test rename to test1;
Table altered.
两个方法亲测都ok