Problem while Importing database
510050Sep 22 2006 — edited Sep 22 2006Hi 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