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,


2 Answers 2

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

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

  • 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, 2011 at 19:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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