Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem while Importing database

510050Sep 22 2006 — edited Sep 22 2006
Hi all,

While trying to import the database of size 11GB i am facing following errors.

IMP-00058: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kcbnew_3], [1], [], [], [], [], [], []
IMP-00028: partial import of previous table rolled back: 2628550 rows rolled back
. . importing table "BT_BILLING_EVENTS_BKP16102003" 0 rows imported
. . importing table "BT_BILLING_EVENTS_OLD" 0 rows imported
. . importing table "BT_BILL_DETAILS" 0 rows imported
. . importing table "BT_DEPOSITDETAILS"
IMP-00058: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kcbnew_3], [1], [], [], [], [], [], []
IMP-00028: partial import of previous table rolled back: 37821 rows rolled back
. . importing table "BT_DUNNING" 0 rows imported
. . importing table "BT_PENALTYTRANSACTION" 0 rows imported
. . importing table "BT_REMINDERS" 0 rows imported
. . importing table "BT_REMINDERS_CONTENT" 0 rows imported
. . importing table "BT_UC_AGREEMENTS" 0 rows imported
. . importing table "BT_UC_RATEPLANS" 0 rows imported
. . importing table "BUS_GEO_INFO" 0 rows imported
. . importing table "CALLENQHISTORY" 0 rows imported
IMP-00017: following statement failed with ORACLE error 600:
"ALTER TABLE "CALLENQHISTORY" ADD PRIMARY KEY ("HISTORYID") USING INDEX PCT"
"FREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 67584 FREELISTS 1 FREELIST "
"GROUPS 1) TABLESPACE "MQSLOAD403" LOGGING ENABLE"
IMP-00003: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kcbnew_3], [1], [], [], [], [], [], []
. . importing table "CAS_REQUESTS_LOG" 0 rows imported
. . importing table "CATALOGUE_FACILITY_DEFS" 2 rows imported
IMP-00017: following statement failed with ORACLE error 600:
"CREATE UNIQUE INDEX "PK_CATALOGUE_FACILITY_DEFS" ON "CATALOGUE_FACILITY_DEF"
"S" ("CATALOGUE_TYPE" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL "
"67584 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "MQSLOAD403" LOGGING"
IMP-00003: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [kcbnew_3], [1], [], [], [], [], [], []
IMP-00017: following statement failed with ORACLE error 600:
"ALTER TABLE "CATALOGUE_FACILITY_DEFS" ADD CONSTRAINT "PK_CATALOGUE_FACILIT"
"Y_DEFS" PRIMARY KEY ("CATALOGUE_TYPE") USING INDEX PCTFREE 10 INITRANS 2 MA"
"XTRANS 255 STORAGE(INITIAL 67584 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "
""MQSLOAD403" LOGGING ENABLE "

Table space configuration is :

for default tablepsace i have given 16GB and added a datafile with 5GB and auto extent is YES

for temporay table sapce 7GB and auto extent is on.

what might be the problem?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2006
Added on Sep 22 2006
6 comments
774 views