Import wirth ora-600
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Import wirth ora-600

  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Import wirth ora-600

    Hello together!

    When I start to import an Oracle Dump to our Test-System I got following error message:

    Microsoft Windows 2000 [Version 5.00.2195]

    (C) Copyright 1985-2000 Microsoft Corp.

    C:\>imp

    Import: Release 8.1.7.4.1 - Production on Fr Dez 17 13:31:31 2004

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Username:

    Password:

    Connected to: Oracle8i Release 8.1.7.4.1 - Production

    JServer Release 8.1.7.4.1 - Production

    Import file: EXPDAT.DMP > i:\expreldl.dmp

    Enter insert buffer size (minimum is 8192) 30720> 10000000

    Export file created by EXPORT:V08.01.07 via conventional path

    import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

    List contents of import file only (ja/nein): nein >

    Ignore create error due to object existence (ja/nein): nein >

    Import grants (ja/nein): ja >

    Import table data (ja/nein): ja >

    Import entire export file (ja/nein): nein > ja

    . importing INFOR's objects into INFOR

    . . importing table "RELDL" 6914467 rows imported

    IMP-00017: following statement failed with ORACLE error 600:

    "CREATE INDEX "RELDL_6" ON "RELDL" ("KNZ_2" , "RELNAME" ) PCTFREE 10 INITRA"

    "NS 2 MAXTRANS 255 STORAGE(INITIAL 235323392 NEXT 25468928 MINEXTENTS 1 MAXE"

    "XTENTS 505 PCTINCREASE 10 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT"

    ") TABLESPACE "VPPSBDI" LOGGING"

    IMP-00003: ORACLE error 600 encountered

    ORA-00600: internal error code, arguments: [sdbput_2], [56908], [], [], [], [], [], []

    IMP-00017: following statement failed with ORACLE error 20000:

    "BEGIN DBMS_STATS.SET_INDEX_STATS
    (NULL,'"RELDL_6"',NULL,NULL,NULL,6909504,2"

    "6162,16,1635,39484,631753,2,0); END;"

    IMP-00003: ORACLE error 20000 encountered

    ORA-20000: Unable to set values for index RELDL_6: does not exist or insufficient privileges

    ORA-06512: at "SYS.DBMS_STATS", line 2374

    ORA-06512: at "SYS.DBMS_STATS", line 2468

    ORA-06512: at line 1

    IMP-00017: following statement failed with ORACLE error 3113:

    "CREATE INDEX "RELDL_15" ON "RELDL" ("BESTELLNR" , "TRAC" ) PCTFREE 10 INIT"

    "RANS 2 MAXTRANS 255 STORAGE(INITIAL 171950080 NEXT 19128320 MINEXTENTS 1 MA"

    "XEXTENTS 505 PCTINCREASE 10 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
    "LT) TABLESPACE "VPPSBDI" LOGGING"

    IMP-00003: ORACLE error 3113 encountered

    ORA-03113: end-of-file on communication channel

    IMP-00000: Import terminated unsuccessfully

    C:\>


    Sometimes the System stops without a error message. Can someone help me?

    Bjoern

  2. #2
    Join Date
    May 2001
    Posts
    736
    use analyze=n.

  3. #3
    Join Date
    Dec 2004
    Posts
    2
    on the next try today, the import still doesn't work.

    it hangs without an error message on the table reldl with a cpu usage 100% no redo log switches an no disk i/o. if i import only the tabele reldl i got the create index messages.

    some ideas to import whole dump?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Originally posted by Bjoern
    on the next try today, the import still doesn't work.

    it hangs without an error message on the table reldl with a cpu usage 100% no redo log switches an no disk i/o. if i import only the tabele reldl i got the create index messages.

    some ideas to import whole dump?
    use indexes=no to see if the tables get imported, is they do create the indexes manually

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