Ed Chen Logic - Page 2 of 92 - To Make My Logic More Logical

How to Resolve ORA-20005: object statistics are locked (stattype = ALL)

by Ed Chen
June 19, 2021July 21, 2021

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 »

Local Undo of PDB for Each RAC Instance

by Ed Chen
June 16, 2021April 27, 2021

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 »

How to Resolve ORA-01502: index or partition of such index is in usable state.

by Ed Chen
June 12, 2021June 16, 2021

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-01439: column to be modified must be empty to change datatype

by Ed Chen
June 9, 2021July 13, 2021

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-01109: database not open

by Ed Chen
June 5, 2021April 1, 2021

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-31693: Table data object failed to load/unload and is being skipped due to error

by Ed Chen
June 2, 2021June 5, 2021

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 Create a Pluggable Database (PDB)

by Ed Chen
May 29, 2021July 2, 2021

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 Drop a Pluggable Database (PDB)

by Ed Chen
May 26, 2021July 2, 2021

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 Resolve ORA-65025: Pluggable database is not closed on all instances.

by Ed Chen
May 22, 2021July 17, 2021

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-65179: cannot keep datafiles for a pluggable database that is not unplugged

by Ed Chen
May 22, 2021March 28, 2021

ORA-65179 Let's see a unsuccessful case of dropping a pluggable database (PDB). SQL> drop pluggable database orclpdb2; drop pluggable database orclpdb2 * ERROR at line… Read More »