ORA-16000: database or pluggable database open for read-only access

 I faced this error message when I tried to drop a table from my PDB which was opened in read-write mode without any restriction.

SQL> drop table test; drop table test            * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: database or pluggable database open for read-only access    SQL> show pdbs   CON_ID    CON_NAME         OPEN MODE        RESTRICTED ---------- ------------------------------ ---------- ---------------------------  3                PDB1                      READ WRITE      NO

ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged

You should use “including datafiles” clause while dropping a pluggable database otherwise ORA-65179 would be returned

SQL> drop pluggable database testpdb; drop pluggable database testpdb * ERROR at line 1: ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged

ORA-65342: source pluggable database has unrecovered transaction

Starting 12.2, if you are planning to clone a PDB locally or remotely, you can do that while source PDB is open in read-write mode (hot cloning). In 12.1, if you start your CREATE PLUGGABLE DATABASE command while a transaction is already active in the source PB, you will be returned ORA-65342. Therefore, the better option is to close the source PDB, and then start it as read-only so that no transactions could hinder the cloning process