alter table system."test_table" rename to system."test_table_old"
=>會出現下面的錯誤
SQL 錯誤: ORA-14047: ALTER TABLE|INDEX RENAME 不可以與其他作業連結
14047. 00000 - "ALTER TABLE|INDEX RENAME may not be combined with other operations"
*Cause: ALTER TABLE or ALTER INDEX statement attempted to combine
a RENAME operation with some other operation which is illegal
*Action: Ensure that RENAME operation is the sole operation specified in
ALTER TABLE or ALTER INDEX statement;
改成下面即可
alter table system."test_table" rename to "test_table_old"
沒有留言:
張貼留言