Using Oracle imp to recover
437968Aug 24 2006 — edited Aug 28 2006Hi,
I'm doing some disaster recovery tests. I use exp to export the database with the following command:
exp \"sys/mypassword AS sysdba\" FULL=y FILE=/data/backup/apex_backup.dmp
If I try and do an import using imp I get a lot of problems importing into the flows_files and flows_020100 schemas. It imports my other schemas perfectly.
How should I import so APEX still works and it still retains my applications?
Thanks,
Martin