exp userid=xxx/xxx file=my_db.dmp log=my_db.log owner=PRODdrop the TEST schema, re-create the TEST user in the DB, then
imp userid=xxx/xxx file=my_db.dmp log=imp.log fromuser=PROD touser=TESTIs it a correct way to do this or is there a simpler way?
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.