How to Find Oracle Table Creation Date Time
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
How to Resolve ORA-20005: object statistics are locked (stattype = ALL)
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)
Local Undo of PDB for Each RAC Instance
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
How to Resolve ORA-01502: index or partition of such index is in usable state.
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.
How to Resolve ORA-01439: column to be modified must be empty to change datatype
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
How to Resolve ORA-01109: database not open
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
How to Resolve ORA-31693: Table data object failed to load/unload and is being skipped due to error
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
How to Create a Pluggable Database (PDB)
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)
How to Drop a Pluggable Database (PDB)
DROP PLUGGABLE DATABASE Since Pluggable Database (PDB) becomes more flexible than dedicated databases, we may create a PDB for some specific purpose, use it for… Read More »How to Drop a Pluggable Database (PDB)
How to Resolve ORA-65025: Pluggable database is not closed on all instances.
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.