Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: No IMP/EXP command in 'help Index'

    Hi ( running oracle 9i)

    I wanted to import a db however, when I issued the imp command, it said, 'Unknown Command'. Checked Help Index and cannot see either IMP or EXP in the list.

    How can I get these 2 utilities?

    Regards

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Post Operating System (OS) name & version for DB server system.
    Post results of
    SELECT * from v$version
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2008
    Posts
    464

    Prob solved...

    Sorry guys...I was running the imp command from sqlplus....Should have run it from the cmd prompt Thanks.

  4. #4
    Join Date
    Oct 2009
    Posts
    5
    hi

    i have exported a table in the command prompt. How to import the table m=now.

    also i thought of running catproc.sql and few scripts in the command prompt but i am unable to run the scripts i get the below error. is there any possibility to execute them.
    SQL> @D:/oracle/ora92/rdbms/admin/catproc.sql
    and i see no response for the above command
    please let me know how to execute the script

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >i have exported a table in the command prompt.
    replace "exp" with "imp"
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Dec 2009
    Posts
    5
    I think your path should have backslashes not the forward slashes.

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    and yes, run it at the command prompt. IMP is NOT a sqlplus command.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •