What are the basic operations of Oracle

This article mainly introduces "what are Oracle basic operations". In daily operation, I believe many people have doubts about what problems Oracle basic operations have. Xiaobian consulted various materials and sorted out simple and easy operation methods. I hope to help you answer the doubts about "what are Oracle basic operations"! Next, please follow the small series to learn together!

Start the database

SQL> startup

SQL> show con_name //View current container

CON_NAME

CDB$ROOT

SQL> show pdbs; //Query all containers of the database

CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ ONLY NO 3 ORCLPDB MOUNTED

SQL> alter pluggable database orclpdb open; //modify pluggable database orclpdb open state

Pluggable database has changed.

SQL> alter session set container=orclpdb; //Switch session to PDB under CDB

Session has changed.

SQL> show con_name //Verify that the current location is in ORCLPDB

CON_NAME

ORCLPDB

SQL> shutdown immediate //shutdown pluggable database in PDB

Pluggable database is closed.

SQL> startup //close pluggable database in PDB

Pluggable database is open.

SQL> alter session set container=cdb$root; //switch session to CDB

Session has changed.

SQL> show con_name //View

CON_NAME

CDB$ROOT

At this point, the study of "What are the basic operations of Oracle" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!