Import wirth ora-600

[Bjoern]

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

[akhadar]

use analyze=n.

[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?

[davey23uk]

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