Scheduled Jobs Running at Wrong Time
If you found this problem in a Pluggable Database (PDB), then we might have the same issue. My finding is that AUTOTASK is always triggered… Read More »Scheduled Jobs Running at Wrong Time
Multitenant
How to Resolve ORA-01109: database not open
ORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… Read More »How to Resolve ORA-01109: database not open
How to Resolve ORA-39195: At least one schema in the TABLE_FILTER does not exist.
ORA-39195 ORA-39195 means that tables that you want to export does not exist in the current database, even though you qualify exported tables by schema… Read More »How to Resolve ORA-39195: At least one schema in the TABLE_FILTER does not exist.
How to Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied
ORA-01045 ORA-01045 means that the user who tried to connect to the database has no privilege to connect to. Therefore, the database refused the user… Read More »How to Resolve ORA-01045: user lacks CREATE SESSION privilege; logon denied
How to Clone PDB to Another CDB
Clone PDB to Another CDB To clone a PDB to a different CDB, we may take the following steps: Close the source PDB. Open the… Read More »How to Clone PDB to Another CDB
How to Create PDB from Another PDB
Create PDB from Another PDB Cloning a new PDB from another pdb for testing purpose in the same CDB is a very common practice during… Read More »How to Create PDB from Another PDB
How to Unplug and Plug a PDB in Different Hosts
The step 1, 2, 3 are same as How to Unplug and Plug a PDB in Same Host, so we skip those steps and directly go… Read More »How to Unplug and Plug a PDB in Different Hosts
How to Unplug and Plug a PDB in Same Host
First of all, check the status of the target PDB to unplug.SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ----------... 4 FINANCE_PDB… Read More »How to Unplug and Plug a PDB in Same Host
Which Container Am I Using? Where Am I?
You may find out there're too many PDB to make you manage them well, waste time to execute useless statements, or get lost in container… Read More »Which Container Am I Using? Where Am I?