Results 1 to 12 of 12
  1. #1
    Join Date
    Jun 2008
    Posts
    4

    Red face Unanswered: import command on Oracle 10g

    Hi,

    I've installed the Oracle 10g Database on Windows 2000 server and now wants to import the database which I'hd taken from another 10g database. But when I try to import the db using following command I'm getting error, -

    ----------------------------------------------------------------
    import MEDAS_IPCL/medas file=E:\medas_ipcl.dmp buffer=200000 full=y commit=y log=medasipclimport.log IGNORE=YES
    ----------------------------------------------------------------

    Error :-
    SP2-0754: Unknown command beginning "import MEDAS.."

    I'm not understanding that why this error getting on SQL plus command prompt. Is import command dose not recognize by the SQL plus or oracle 10g ???

    Please guide me if I'm doing anything wrong.

    Thanks.
    Ashwin.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    IMPORT utility is to be run at operating system prompt, not SQL*Plus.

  3. #3
    Join Date
    Jun 2008
    Posts
    4
    Could you Plz. let me know what's the exact procedure for it? As from which login I've to do this and in which directory. Whenever I want to login from the DB username/password it won't allow me to login. I always have to login by system user. Will it upload the db at right database or will it create new db from the upload db name ?

    Plz. help me....

    BTW Thanks. for the prompt reply.

    Ashwin.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    This is the Oracle 10g Utilities book; as you are interested in import (and not data pump import), you should pay attention to chapter 19: Original Export and Import. Study what's written in there and you should be able to perform both export and import.

    If there's still something you don't understand, say so.

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    Once you open a command window, then maybe the command is not import but imp.

    .
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Jun 2008
    Posts
    4

    Red face

    Hey,

    Thanks for the help but now I'm getting the following error after using the command, -

    ===========================================
    imp medas_ipcl/oracle@ora10g file=E:\medas_ipcl.dmp buffer=200000 full=y commit=y log=medasipclimport.log IGNORE=YES
    ===========================================

    Error:
    ===========================================
    IMP-00058: ORACLE error 12154 encountered
    ORA-12154: TNS:could not resolve the connect identifier specified
    IMP-00000: Import terminated unsuccessfully
    ===========================================

    Else all the login credentials are OK but I don't know why I'm getting this error on command prompt.

    Please help me as I can't upload the DB.....

    Ashwin.

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Check the tnsnames.ora file!

    Code:
    set ORACLE_HOME = C:\your\oracle\home
    set ORACLE_SID = ora10g
    imp medas_ipcl/oracle file=E:\medas_ipcl.dmp buffer=200000 full=y commit=y log=medasipclimport.log IGNORE=YES
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  8. #8
    Join Date
    Jun 2008
    Posts
    4

    Red face

    All the settings are correct as per you mentioned; But still I can't fire the command successful. Could you please help me little bit more.......?

    Thanks.

    Ashwin.

  9. #9
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Post SQLNET.ORA and TNSNAMES.ORA files. Use [code] tags to preserve formatting.

  10. #10
    Join Date
    May 2008
    Posts
    10
    I am facing the same problem as Ashwin. Tried almost everything. And studied Original Export and Import chapter. I have also set up oracle home, path and library correctly.
    But still can't do export...
    WEIRED........

  11. #11
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Read http://www.dbforums.com/showthread.php?t=1031644
    especially the part about VB <code tags>
    What Operating System name & version?
    use CUT & PASTE to show use what EXACTLY you are doing & what is/was the response and post results back here
    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.

  12. #12
    Join Date
    May 2008
    Posts
    10
    my apologies folks, following seems to be wroking perfectly fine now;

    exp schema_name/password@database

    Ashwin, I think you need to double check if you have set up oracle home, path etc accordingly, for the export utility.

    for example;

    bash-2.03$ export ORACLE_HOME="/oracle/app/oracle/product/10g"
    bash-2.03$ export PATH=$PATH:$ORACLE_HOME/bin
    bash-2.03$ export NLS_LANG="AMERICAN_AMERICA.UTF8"
    bash-2.03$ export PARFILE="<PARFILENAME.par_file_type>" -- myparfile.par OR myparfile.txt (there are no restriction on the PARFILE type)


    You can check you export utility settings by using the following command;

    bash-2.03$ export

    Make sure all the settings are correct, specify dump file name, it's location etc

    It worked for me, hope it works for you too.

    If doing an Import, then I am sure you can mak ethe minor changes accordingly.

Posting Permissions

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