Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: error during import

    Hi,
    I've a export file (XX.dmp).
    I tried to import this dump for new records of tables there are in my db, but I get this errors:

    imp system/manager@mydb file=xx.dmp tables=A ignore=y fromuser=tom touser=tom log=xx.log

    Export file created by EXPORT:V09.02.00 via conventional path
    import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
    . importing AFM's objects into AFM
    IMP-00017: following statement failed with ORACLE error 922:
    "CREATE TABLE "SITE" ("ACRES" FLOAT(126), "AREA_EM_DP" FLOAT(126) "NOP" VARCHAR2(4)) PC"
    "TFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 4980736 FREELIS"
    "TS 1 FREELIST GROUPS 1) TABLESPACE "AFM_P1" LOGGING NOCOMPRESS"
    IMP-00003: ORACLE error 922 encountered
    ORA-00922: missing or invalid option
    IMP-00008: unrecognized statement in the export file:
    o
    IMP-00008: unrecognized statement in the export file:
    R
    IMP-00008: unrecognized statement in the export file:

    I think that export file is was corrupted.
    How Can I import correctly??

    Thanks
    Raf

  2. #2
    Join Date
    Jul 2002
    Posts
    227
    My db server is 9.0.1, while export made on oracle server 9.2.0.1
    On server 9.2.0.1 not is setting the NLS_LANG
    Could be this the problem???

    Thanks
    Raf

  3. #3
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    I think it might be the nocompress/compress option available in 9.2 which might be giving you grief. You might want to remove this text from the dmp file using some utility. Alternatively you might try doing the export from the 9.0.1 machine but it might not work.

    The last option is to create a schema script from 9.2 schema, removing the compress/no compress text. Run the schema script on the 9.0.1 machine and then import with ignore=Y option so it will ignore any create table errors.

    Alan

  4. #4
    Join Date
    May 2003
    Posts
    5

    Cool

    Hi there,
    I think it is problem with NOT NULL columns constraints, u can disable those constraints and try again. if it still not work then u can use the SHOW=y option to verify your DMP file. The SHOW option will show u what are the object is there in the DMP file and how it is going to import. Just check out it.
    Wish u all the best.
    Ravi

  5. #5
    Join Date
    Nov 2002
    Posts
    833
    AFAIK Oracle exp/imp utilities are not downward compatible

    try exporting SID 9.0.2 using exp from 9.0.1 utilities' version

Posting Permissions

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