https://livesql.oracle.com/apex/f?p=590:1000:100225800561367
Author: rparvu
Strange error when renaming a table
ORA-14047: ALTER TABLE INDEX RENAME may not be combined with other operations When we try to rename a table or index name in Oracle, we use a simple command as following ALTER TABLE“[SCHEMA_NAME]“.“[OLD_TABLE_NAME]“RENAME TO“[NEW_TABLE_NAME]“; If we put into schema names to this command, we can deal with ORA-14047 error.This error raise when we put schema […]
