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!

Create a database clone with no data,only the tablespaces and table structures

raynMay 7 2015 — edited May 8 2015

I have to create a empty database which contains all the tables and object from "Database A" but those table should not contain any data. I can think about two approaches

- RMAN clone then truncate all tables

- EXPDP/IMPDP only schemas, but what about the 150 tablespaces "Database A" has

What would you guys suggest?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2015

Added on May 7 2015

#general-database-discussions

6 comments

1,580 views