Overwrite User Tables/Views/etc. From Oracle Export File
Posted on 2006-05-16
I am having an Oracle import issue. Currently, I have an export from a production database. There is an existing test database that I want to overwrite with the production data (schema objects / data) for one user only.
As a side note, I do NOT have the sys password and dropping/recreating the user on the test instance is not an option.
After reviewing the Oracle documentation, it is not immediately apparent how to do this.
Surely, this is a common task. Please advise the best way to do this.
Thanks, any help is greatly appreciated.
All the best.