1.创建PDB
CREATE PLUGGABLE DATABASE DB_CROSS
ADMIN USER pdbadmin IDENTIFIED BY enmo#2023
ROLES = (dba)
DEFAULT TABLESPACE CROSS_TBS
DATAFILE '/chac/app/oradata/CROSS/DB_CROSS/cross01.dbf' SIZE 250M AUTOEXTEND ON
FILE_NAME_CONVERT = ('/chac/app/oradata/CROSS/pdbseed/',
'/chac/app/oradata/CROSS/DB_CROSS/')
PATH_PREFIX = '/chac/app/oradata/CROSS/DB_CROSS/';
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 CROSSPDB READ WRITE NO
4 DB_CROSS MOUNTED
SQL> alter pluggable database DB_CROSS open read write;
Pluggable database altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 CROSSPDB READ WRITE NO
4 DB_CROSS READ WRITE NO
[oracle@c-ross-test-database-01-20231215 DB_CROSS]$ ll
总用量 1034332
-rw-r----- 1 oracle oinstall 471867392 12月 18 15:06 sysaux01.dbf
-rw-r----- 1 oracle oinstall 377495552 12月 18 15:06 system01.dbf
-rw-r----- 1 oracle oinstall 93331456 12月 18 15:06 temp012023-12-18_13-26-17-577-PM.dbf
-rw-r----- 1 oracle oinstall 209723392 12月 18 15:06 undotbs01.dbf
SQL> select TABLESPACE_NAME from dba_tablespaces;
TABLESPACE_NAME
------------------------------------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
CROSS_TBS
注意事项:
创建PDB时需要指定PDB里面一个管理用户,同时指定用户使用的表空间。种子数据库的路径和新的PDB的路径。
2.删除PDB
--先关闭数据库,然后删除。关闭后是mount状态可以删除。
alter pluggable database db_cross close;
SQL> drop pluggable database db_cross including datafiles;
Pluggable database dropped.
3.创建自定义用户并授予权限。
alter session set container=DB_CROSS;
create user cross identified by enmo#2023;
alter user cross default tablespace cross_tbs;
grant create session ,connect,resource,unlimited tablespace to cross;