2012年12月19日 星期三

table rename

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"

沒有留言: