-
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
-
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|