创建PDB
2019-10-14 本文已影响0人
如果不是废物谁又愿混吃等死
1、sqlplus / as sysdba
2、create pluggable database testorcl
admin user testorcl identified by testorcl
file_name_convert=('D:\oracle\app\orcl\oradata\orcl','D:\oracle\app\orcl\oradata\orcl\testorcl');
3、alter session set container = testorcl;
4、startup;
1、create user username identified by password;
2、grant dba to username;
TNS中添加:
TESTORCL =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTORCL)
)
)
删除
1、alter pluggable database testorcl close immediate; --变更状态
2、drop pluggable database testorcl including datafiles; --删除
