Shulou(Shulou.com)06/01 Report--

SQL > show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

-

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 TEST MOUNTED

SQL > alter pluggable database test open

Alter pluggable database test open

*

ERROR at line 1:

ORA-65086: cannot open/close the pluggable database

SQL > select pdb_name,status from dba_pdbs

PDB_NAME STATUS

--

PDB NORMAL

PDB$SEED NORMAL

TEST UNPLUGGED

I've done alter pluggable database before. Unplug into '...'; but I don't know which directory unplug into's xml file went to.

Alter pluggable database can be re-executed. Unplug into '...'

SQL > alter pluggable database test unplug into'/ u01max test.xml'

Pluggable database altered.

SQL > create pluggable database test using'/ u01Charger test.xml' nocopy tempfile reuse

Pluggable database created.

SQL > show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

-

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 TEST MOUNTED

SQL > alter pluggable database test open

Pluggable database altered.

SQL > show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

-

2 PDB$SEED READ ONLY NO

3 PDB READ WRITE NO

4 TEST READ WRITE NO

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.