—————————————————————————————————创建
CREATE PLUGGABLE DATABASE "NEW_PDB" ADMIN USER "Admin" IDENTIFIED BY "oracle"
FILE_NAME_CONVERT=(
'/u01/app/oracle/oradata/PRODCDB/pdbseed/', '/u01/app/oracle/oradata/PRODCDB/pdbprod4/'
)
STORAGE UNLIMITED;
CREATE PLUGGABLEDATABASE lipdb ADMIN USER lipdbdba IDENTIFIED BY lipdbdba STORAGE (MAXSIZE 5G MAX_SHARED_TEMP_SIZE100M) DEFAULT TABLESPACE tbs_pdb2 DATAFILE'+DATA01' SIZE 100M AUTOEXTEND ON;
—————————————————————————————————通过OMF创建
mkdir /u01/app/oracle/oradata/PRODCDB/pdbprod4
alter system set db_create_file_dest='/u01/app/oracle/oradata/PRODCDB/pdbprod4';
create pluggable database pdbprod4 admin user admin identified by oracle storage unlimited;
alter pluggable database pdbprod4 open;
alter pluggable database all save state;
—————————————————————————————————插入数据
create directory d1 as '/home/oracle/scripts';
create tablespace example;
create tablespace users;
expdp system/oracle directory=d1 dumpfile=user.tmp schemas=hr,sh,oe;
impdp system/oracle@pdbprod4 directory=d1 dumpfile=user.tmp;
select username from dba_users where username in('HR','SH','OE');