Database Software

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 PDB by taking only one schema from several schema with you

Norbert.HeinSep 18 2020 — edited Sep 18 2020

there is a Oracle DB multinenant 19C / Solaris

one PDB with schema1, schema2, schema3 inside

want to create a PDB clone with only the schema1

of course, I ca make a full clone and delete the schema2 and schema3 after

is it possible to clone this PDB direct with only one of this, schema1 ?

maybe using user_tablespaces_clause ?

regards

Norbert

Added on Sep 18 2020

#database-key-features, #multitenant

1 comment

612 views