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?

Views: 21

▶ Reply to This

Replies to This Discussion

Permalink Reply by Virgilio Fukuda on September 13, 2013 at 4:57pm

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.

▶ Reply to Discussion

RSS

Oracle Jobs in US

Groups

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service