error during import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: error during import

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    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:

    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
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    export again and import again....
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Does the table exist ? Have you tried with ignore=y ? And are you using Automatic Segment Space Management by any chance ?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    Jul 2002
    Posts
    228
    imp system/manager@mydb file=xx.dmp tables=A ignore=y fromuser=tom touser=tom log=xx.log

    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

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by raf
    My db server is 9.0.1, while export made on oracle server 9.2.0.1
    In general, you can't "downgrade" directly using the export file. Search this forum on how to import a different version of an export file.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: error during import

    Originally posted by raf
    "TS 1 FREELIST GROUPS 1) TABLESPACE "AFM_P1" LOGGING NOCOMPRESS"
    IMP-00003: ORACLE error 922 encountered
    ORA-00922: missing or invalid option
    COMPRESS/NOCOMPRESS for tables is valid option in 9.2, but not in 9.0, that's why it's complaining about invalid option.

    You have to perform export with 9.0 exp utility to be able to import it into 9.2.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

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



Click Here to Expand Forum to Full Width