Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    17

    Unhappy Unanswered: IMP-00008: unrecognized statement in the export file:

    Hi All,


    I have taken export on the oracle 10.2.0.1.0
    Operation System is Windows XP professional Verison 2002 Service pack 2

    export command

    exp cobra/cobra statistics=none FILE=d:\db\cobra_new.dmp LOG=d:\db\logs.log

    export is starting with
    Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
    Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set


    Export and ends with

    Export terminated successfully without warnings.


    For Import environment is as


    Version is Oracle Database 10g Release 10.1.0.2.0 - Production
    Operating system Windows Server 2003 Enterprise Edition


    For import it was giving error so I have takes all tables script from
    source database and created all the tables in the destination database.

    Now I am trying to import with following command

    imp cobra/cobra FROMUSER=cobra TOUSER=cobra FILE=d:\sandeep\cobra_new.dmp LOG=d:\sandeep\logs.log statistics=none ignore=Y

    On importing following error message


    Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production

    Export file created by EXPORT:V10.02.01 via conventional path
    import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
    IMP-00008: unrecognized statement in the export file:



    In import not all the data gets import.

    I am not able to understand what to do.

    Please advice.


    Thanks and Regards,
    Sandeep Sutar

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Oracle does not allow exp from higher version (V10.2) & then imp into lower (V10.1) version.
    If V10.1 imp is to be used, then V10.1 exp must be first used.
    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
    Dec 2003
    Posts
    1,074
    If you instead go with expdp (Export DataPump), then you can export from a more recent version into an earlier version. To do so, you need to perform the export using the VERSION parameter, specifying the version of the database that you want to impdp into.

    You should move away from exp to expdp anyway, if you're now dealing with version 10+. It offers performance advantages.

    --=cf

Posting Permissions

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