oracle 12c 13姨
时间:2021-07-01 10:21:17
帮助过:8人阅读
PLUGGABLE DATABASE gdlhjd ADMIN USER coder IDENTIFIED
BY coder STORAGE(MAXSIZE
2G MAX_SHARED_TEMP_SIZE
100M)
DEFAULT TABLESPACE hydg DATAFILE
‘E:\GDLHJD\gdlhjd.dbf‘ SIZE
25M AUTOEXTEND
ON;
SQL> col pdb_name
for a20
SQL>
select pdb_name,status
from dba_pdbs;
SQL> alter pluggable database gdlhjd open;
SQL>
select pdb_id,pdb_name,dbid,status,creation_scn
from dba_pdbs;
--至此,用户coder已经可以登录
参考文章:
ORACLE 12C新特性——CDB与PDB
oracle 12c 13姨
标签: