Possibility for clean impdp without 'drop user cascade'?
874056Jul 7 2011 — edited Jul 15 2011First 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