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?
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With