how to empty a database in oracle

Question

We have an old database in oracle 10g. we want to replace it with the new dmp file (that is what we have). Can I simply drop the old database, then run the impdp to create a new one? We are not worried about the data in the old database. Could you give me the steps to do that?

Do you want to overwrite the entire database or just one schema (=user)? The term "database" in Oracle refers to the whole installation including all schemas/users that you have created. — user330315
– user330315, Commented May 3, 2012 at 19:16
just one schema. I guess. Anyway, i was told if dmp file is used, it will recreate everything. Can I use impdp SYSTEM/password to do that? — ericyoung
– ericyoung, Commented May 3, 2012 at 19:19
Do a drop user foobar cascade beforehand. And yes impdp is the way to go (if the .dmp was created using expdp and not with exp) — user330315
– user330315, Commented May 3, 2012 at 20:07

DCookie · Accepted Answer · 2012-05-03 21:49:38Z

4

As has been stated in the comments, you can just drop the user with cascade, then import the user.

If you created an export with the older exp command, and it was an export of just one user/schema, then you will likely have to create the user/schema manually before running the imp. exp/imp were not as smart about that as expdp/impdp.

answered May 3, 2012 at 21:49

DCookie

43.7k11 gold badges88 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to empty a database in oracle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related