Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Clone Pluggable Database with NO DATA still copy DATA

mpatzwahlOct 21 2023

Hi, I have Oracle 23c FREE Edition and would like to clone a Plug DB without Data:

ALTER PLUGGABLE DATABASE pdb1 CLOSE IMMEDIATE;

ALTER PLUGGABLE DATABASE pdb1 OPEN READ ONLY;

CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
STORAGE UNLIMITED
FILE_NAME_CONVERT=(
'/PDB1',
'/PDB2 ')
NO DATA;

ALTER PLUGGABLE DATABASE pdb2 OPEN;

ALTER PLUGGABLE DATABASE pdb1 CLOSE;

ALTER PLUGGABLE DATABASE pdb1 OPEN;

But after this PDB2 has the same Data like PDB1. Why ?

Thanks, Marco

Comments
Post Details
Added on Oct 21 2023
8 comments
1,290 views