Solved

IMPORT ERROR WHEN USING TOAD

Posted on 2009-07-06
3
2,587 Views
Last Modified: 2013-12-19
I received an oracle dmp file together with a log file which was generated using the oracle export utility.  I have been trying to import the schema and data into my oracle database using TOAD Import Utility Wizard.  I put in the path and name of the dmp file and also of the log file.  When I try to run the wizard by clicking finish - it gives me the error saying - The Oracle Import Utility executable must be specified.  I go back but there is no window which asks for the executable - neither do I know where it is.  I am running this on the system schema.  I would greatly appreciate any kind of help.  I am using oracle 11.1.
Bill_388
0
Comment
Question by:Bill_388
  • 2
3 Comments
 
LVL 21

Expert Comment

by:oleggold
ID: 24789853
go to view options executebales
0
 
LVL 21

Accepted Solution

by:
oleggold earned 500 total points
ID: 24789887
this is the place,write the path to import,generaly it's in oracle schema ,like c:\oracle\bin
imp.jpg
1
 

Author Closing Comment

by:Bill_388
ID: 31600386
Thanks oleggold.  I tried it once, got an error, created the appropriate user and tabledefs and it worked like a charm.  It would have taken me days to figure that out as a newbie.  You saved me a lot of time.  Again, thank you very much.

Bill_388
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to take different types of Oracle backups using RMAN.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question