oracle多租户(ofm创建默认表空间和默认表空间克隆)

使用ofm创建PDB2，不指定表空间
CREATE PLUGGABLE DATABASE pdb2
ADMIN USER pdb_adm IDENTIFIED BY aabb123;
ALTER PLUGGABLE DATABASE pdb2 OPEN READ WRITE;

ALTER SESSION SET CONTAINER = pdb2;
SELECT tablespace_name
FROM dba_tablespaces;

SELECT property_value
FROM database_properties
WHERE property_name = ‘DEFAULT_PERMANENT_TABLESPACE’;

创建PDB指定表空间
ALTER SESSION SET CONTAINER = cdb$root;
CREATE PLUGGABLE DATABASE pdblh ADMIN USER pdb_adm IDENTIFIED BY aabb123
DEFAULT TABLESPACE pdblh DATAFILE SIZE 1M AUTOEXTEND ON NEXT 1M;
ALTER PLUGGABLE DATABASE pdblh OPEN;

ALTER SESSION SET CONTAINER = pdblh;
SELECT tablespace_name
FROM dba_tablespaces;

SELECT property_value
FROM database_properties
WHERE property_name = ‘DEFAULT_PERMANENT_TABLESPACE’;

克隆时指定默认表空间
创建个新的PDB
ALTER SESSION SET CONTAINER = cdb$root;
CREATE PLUGGABLE DATABASE pdbzs ADMIN USER pdb_adm IDENTIFIED BY aabb123
DEFAULT TABLESPACE zs DATAFILE SIZE 1M AUTOEXTEND ON NEXT 1M;
ALTER PLUGGABLE DATABASE pdbzs OPEN;


连接到pdbzs查看
ALTER SESSION SET CONTAINER = pdbzs;
SELECT property_value
FROM database_properties
WHERE property_name = ‘DEFAULT_PERMANENT_TABLESPACE’;

创建表空间
show CON_NAME
CREATE TABLESPACE test_ts DATAFILE SIZE 1M AUTOEXTEND ON NEXT 1M

查看PDBZS表空间

克隆PDB指定默认表空间
ALTER SESSION SET CONTAINER = cdb$root;
show CON_NAME
show pdbs
CREATE PLUGGABLE DATABASE pdblisi FROM pdbzs
DEFAULT TABLESPACE test_ts;
ALTER PLUGGABLE DATABASE pdblisi OPEN;

ALTER SESSION SET CONTAINER = PDBLISI;
show CON_NAME
SELECT tablespace_name
FROM dba_tablespaces;

SELECT property_value
FROM database_properties
WHERE property_name = ‘DEFAULT_PERMANENT_TABLESPACE’;