We usually retrieve table information from ALL_TABLES, but it has no table creation date. This is because table is also an object type, so we… Read More »How to Find Oracle Table Creation Date Time
ORA-20005 When we tried to gather some statistics on an index which has never been analyzed, we saw ORA-20005 like this: SQL> exec dbms_stats.gather_table_stats(ownname =>… Read More »How to Resolve ORA-20005: object statistics are locked (stattype = ALL)
Usually, we have separate undo tablespace for each instance in a RAC database. For example, UNDOTBS1 is for the first instance and UNDOTBS2 is for… Read More »Local Undo of PDB for Each RAC Instance
ORA-01502 ORA-01502 means that the index that the optimizer want to use is in UNUSABLE state, you can either rebuild it or work around it.… Read More »How to Resolve ORA-01502: index or partition of such index is in usable state.
ORA-01439 ORA-01439 means that the data type of a column you want to change is not empty, you have to make it empty first, then… Read More »How to Resolve ORA-01439: column to be modified must be empty to change datatype
ORA-01109 ORA-01109 is pretty normal when your database is close, mostly it's previously shutdown manually by someone, or the database shutdown itself by accident, you… Read More »How to Resolve ORA-01109: database not open
ORA-31693 Found errors when import data from a dump file. ORA-31693: Table data object "ERPAPP"."MONTHLY_PAYMENT" failed to load/unload and is being skipped due to error:… Read More »How to Resolve ORA-31693: Table data object failed to load/unload and is being skipped due to error
There're several ways that can create a PDB. Create a PDB by using SQL*Plus Create a PDB by using DBCA Create a PDB by cloning… Read More »How to Create a Pluggable Database (PDB)
ORA-65025 ORA-65025 means that the pluggable database should be closed completely before dropping. Let's see a case of dropping a PDB. SQL> drop pluggable database… Read More »How to Resolve ORA-65025: Pluggable database is not closed on all instances.