Tag: Oracle

Resize Operation Completed For File# (Doc ID 1982901.1)

In 12c and above, you may see messages similar to the following message in the alert log Resize Operation Completed For File# 23, old size 1024K, new size 2048K That means the data file is defined as auto extensible and when data in the file is increasing and the size of the file needs to … Continue reading Resize Operation Completed For File# (Doc ID 1982901.1)

ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations

Have your ever tried to rename an Oracle table or index and got this error: ORA-14047? According to Oracle's docs, the following is the syntax of changing a table or index name: ALTER TABLE [schema.]table_name RENAME TO <new_table_name>; ALTER INDEX [schema.]index_name RENAME TO <new_index_name>; Note the new table/index name should NOT have the schema name … Continue reading ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations