Skip to Main Content

Database Software

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!

Possibility for clean impdp without 'drop user cascade'?

874056Jul 7 2011 — edited Jul 15 2011
First time poster here.

Unlike many readers here, our organization has the super duper DBA group who are very sensitive about what we do to the servers. While it is understandable for what they do, it is also a headache for us, too.

Setup: We have 2 servers on 11g, one PROD, and one QA. The DBA takes a database dump from PROD via expdp and give it to us to restore on QA. The plan is to drop and recreate user before running impdp.

The problem is that we do not have the privileges to "connect /as sysdba" so we can drop and recreate the user, and we won't get to have it.

It it just as good if:

(1) we drop all the tables, procedures, sequences, and etc, then run impdp

(2) there is an option to run impdp which will force overwrite the database?

(3) there exists other alternatives to do complete schema refresh?

Thanks in advance for your advices.

David
This post has been answered by Brian Bontrager on Jul 14 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2011
Added on Jul 7 2011
3 comments
9,333 views