Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

the company receives several Oracle database dumps from clients for analysis. My programmers are not Oracle literate and find it difficult to restore the dumps using the IMP utility.

They need a graphical interface over IMP to make restoring the dumps easier.

It should make it easy to restore the dump to a different database user AND to a different table space without the need to use arcane command line options.

suggestions anyone ?

Thank you,


share|improve this question
Here are the commands that I run in sqlplus to create the directory and sample shell scripts that do the imports and exports:

Commands to run in sqlplus prior to running inport:

grant create any directory to EPADMRT;
create or replace directory MY_DIR as '/content_services/alan';

Sample import shell script:

impdp EPADMRT/ART schemas=CHECK_DB directory=my_dir dumpfile=CHECK_DB.dmp logfile=impdp_CHECK_DB.log

For an export, here is what I run in sqlplus:

grant create any directory to EPADMRT;
create or replace directory MY_DIR as '/u01/home/oracle/alan';

And here is a sample shell script that I run to do the export:

expdp  EPADMRT/ART schemas=CHECK_DB directory=MY_DIR dumpfile=CHECK_DB.dmp logfile=expdpCHECK_DB.log
share|improve this answer

Don't know much about Navicat but found it on a quick search of the web. It might do what you want.

share|improve this answer
Checked it. Its a lot more complicated than what I need. Seens to have the features I need. I´ll get approval for the purchase and see if it does the job. Thanks. – Fabio Feb 11 '11 at 19:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.