Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import data block size error 1

Status
Not open for further replies.

haste

Programmer
Feb 27, 2005
96
GH
Am having a prob importing a dump keep getting this error
Code:
IMP-00017: following statement failed with ORACLE error 604:
 "CREATE INDEX "EUL5_DHN_DBH_I" ON "EUL5_DBH_NODES" ("DHN_HI_ID" )  
PCTFREE 1"
 "0 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 573440 NEXT 516096 
MINEXTENTS 1 M"
 "AXEXTENTS 505 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
DEFAU"
 "LT) TABLESPACE "ORION93" LOGGING"
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data 
block
ORA-00600: internal error code, arguments: [4193], [0], [78], [], [], 
[], [], []

 . importing table               "EUL5_DOCUMENTS"          0 rows 
imported
IMP-00017: following statement failed with ORACLE error 604:

Am not sure how the block size is interfering cause the machine I made the dump from uses block size 8192 and I specified that while importing
 
This may help; If you have access to Metalink you can see the whole message

ERROR:
ORA-600 [4193] [a]

DESCRIPTION:

A mismatch has been detected between Redo records and Rollback (Undo) records.
We are validating the Undo block sequence number in the undo block against the Redo block sequence number relating to the change being applied.
This error is reported when this validation fails.

Solution Description:
=====================

In all cases, the ideal solution for a corrupted ROLLBACK SEGMENT is to restore your backup and do a point in time recovery to just prior to when the problem occurred.

Solution Explanation:
=====================

Recover to a point in time before corruption occurred.

Alex
 
Thanks for the reply didn't know that metalink was such a useful reference.
 
Unfortunately metalink registration isn't free
 
Indeed, thats why I asked if you had access :-(

Alex
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top