您好,登錄后才能下訂單哦!
前提: 安裝好數(shù)據(jù)庫(kù)軟件,并創(chuàng)建好CDB模式的數(shù)據(jù)庫(kù)。
本文介紹內(nèi)容: 一、 如何創(chuàng)建pdb,并創(chuàng)建表空間,用戶
二、 并通過database link 在線跨服務(wù)器克隆此pdb。
sqlplus / as sysdba
select name from v$datafile;
CREATE PLUGGABLE DATABASE YXC ADMIN USER YXC_ADMIN IDENTIFIED BY YXC_ADMIN123
STORAGE (MAXSIZE 32G)
DEFAULT TABLESPACE YXC_DATA
DATAFILE '/u01/app/oracle/oradata/yun/YXC/YXC_DATA01.dbf' SIZE 1024M AUTOEXTEND ON
PATH_PREFIX = '/u01/app/oracle/oradata/yun/YXC/'
FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/yun/pdbseed',
'/u01/app/oracle/oradata/yun/YXC');
create tablespace YXC_IDX datafile
'/u01/app/oracle/oradata/yun/YXC/YXC_IDX01.dbf' size 1024m
autoextend on next 200m maxsize unlimited;
(1)更改表空間文件名稱:
alter tablespace YXC_DATA rename datafile
'/u01/app/oracle/oradata/yun/YXC/YXC_DATA01.dbf'
to '/u01/app/oracle/oradata/yun/YXC/YXC_DATA02.dbf';
需要事先在操作系統(tǒng)層面創(chuàng)建目標(biāo)文件。
(2)刪除表空間
alter database default tablespace YXC_DATA;
如果是默認(rèn)表空間,需要提前將默認(rèn)表空間改成其它表空間 :
alter database default tablespace USERS;
create user yxc identified by yxc123 default tablespace YXC_DATA;
grant connect ,resource to yxc;
grant imp_full_database,unlimited tablespace to yxc;
SQL> create user c##clone identified by clone123 container=all;
SQL> grant dba to c##clone container=all;
create database link dblink_clone connect to c##clone identified by andy using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =源端IP)(PORT = 1521))(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME =源端CDB服務(wù)名)))';
SQL> alter session set pdb_file_name_convert='yxc','yxc_clone';
SQL> create pluggable database yxc_clone from yxc@dblink_clone;
SQL> alter pluggable database yxc_clone open;
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。