oracle日常记录

登录

[oracle@CentOS8 log]$ sqlplus system/password as sysdba

查看pdb

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORA19CPDB                      READ WRITE NO

切换pdb

SQL>  alter session set container=ora19cpdb;

Session altered.

查看实例

SQL> select instance_name, status from v$instance ;

当前连接

SQL> show con_name;

删除表空间

drop tablespace gsc007 INCLUDING CONTENTS;