Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to empty a database in oracle

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?

like image 379
ericyoung Avatar asked Oct 07 '22 22:10

ericyoung


1 Answers

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.

like image 86
DCookie Avatar answered Oct 12 '22 09:10

DCookie