Oracle_12c_PDB创建方式

最新推荐文章于 2023-12-12 11:37:53 发布

原创最新推荐文章于 2023-12-12 11:37:53 发布 · 767 阅读

0 ·

CC 4.0 BY-SA版权

Oracle 专栏收录该内容

12 篇文章

订阅专栏

本文详细介绍了在Oracle环境中创建可插拔数据库(PDB)的过程，包括使用FILE_NAME_CONVERT参数进行路径转换，通过OMF方式创建PDB，并演示了如何进行数据目录创建、表空间配置、数据导入导出等关键操作。

—————————————————————————————————创建

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');