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)
Tag: Oracle
Oracle ADR partition full due to large trace files
If you have an Oracle database 12c (12.2.0.1+) system, you may notice the size of the partition where ADR resides increases rapidly. And when you dig into it, you will find most of space is likely used by trace files. Basically there are two issues since Oracle 12.2.0.1: Large size of trace files created during … Continue reading Oracle ADR partition full due to large trace files
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
JoeLi's TechLife 