SYNTAX-- imp userid/password@database_name file='path of dmp file' full=y e.g- imp system/manager@orcl file='c:\dabasefile.dmp' full=y ...

I'm an auditor, and while I have a smattering of programming experience, this is far beyond me. I use IDEA (distributed by Audimation) to analyze tables and such, and usually receive data in the form ...

oracledirectory://DATA_PUMP_DIR/foo.dmp oracledirectory:///opt/oracle/oradata/admin/ORCLCDB/dpdump/foo.dmp oracledirectory://username:password@host:port/database?dir ...

Export or import with Oracle Data Pump In Oracle 10g, exp and imp have been redesigned as the Oracle Data Pump (although Oracle still ships and fully supports exp and imp). If you're used to exporting ...