Recently someone truncated all our tables in a particular schema in an Oracle DB. The infrasture team have restored the server to a temp server in order for me to copy off the files that I need.
What's the best way to do this? Copy each table, view, sequence one by one.
Export to a dump file
expdp scott/tiger@db10g schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log
If I import a dumpfile will it just overwrite the schema I have on production?
Any help would be greatly appeciated.