OraFAQ Forum: Server Administration » Import from 8i to 9i

Home » RDBMS Server » Server Administration » Import from 8i to 9i - ORA-00600

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import from 8i to 9i - ORA-00600 [message #59393]

Sun, 16 November 2003 21:51

LT
Messages: 29
Registered: August 2003

Junior Member

Hi

I have recently installed 9i version one on a brand new server. I exported the data from my old 8i installation and tried to import it into 9i.

Things went great but I got some errors on a few of the tables which I tried to import. A snippet from my import log file which shows one of the errors is shown below. I assume that it has something to do with the DDL syntax used but I am not aware of any differences between 8i and 9i. Await your help...............

SNIPPET.....................................

. . importing table "CLAIM_TRANSACTION_IMPORT_SEQ" 319 rows imported
. . importing table "CLAIM_XREF" 6578 rows imported
. . importing table "CL_ICD_SEARCH" 7 rows imported
. . importing table "COLLECTION_REPORT" 10 rows imported
IMP-00017: following statement failed with ORACLE error 600:
"CREATE TABLE "CORRESPONDENCE" ("CORRESPONDENCE_ID" NUMBER(8, 0), "DOC_ID" V"
"ARCHAR2(10) NOT NULL ENABLE, "IFNDS" NUMBER(9, 0), "IFNID" NUMBER(9, 0), "D"
"OC_TYPE" VARCHAR2(30), "NPAGES" NUMBER(5, 0), "SCAN_DATE" DATE, "MEMBER_COD"
"E" VARCHAR2(9), "CLAIM_NO" VARCHAR2(10), "DOCUMENT_DATE" DATE, "TITLE" VARC"
"HAR2(50), "DESCRIPTION" VARCHAR2(255), "CORRESP_COMMENT" VARCHAR2(2000), "P"
"REVIOUS_CORRESPONDENCE" NUMBER(8, 0), "DIRECTION" VARCHAR2(3), "ASSIGNED_DE"
"PT" VARCHAR2(2), "ASSIGNED_TEAM" VARCHAR2(3), "ASSIGNED_USER" VARCHAR2(5), "
""DATE_ASSIGNED" DATE, "STATUS" VARCHAR2(20), "DATE_COMPLETED" DATE, "RECALL"
"_DATE" DATE, "PRIORITY" VARCHAR2(10), "LAST_UPDATE_USER" VARCHAR2(5), "CASE"
"_FILE_SECTION" VARCHAR2(30), "SENT_FROM" VARCHAR2(30), "SENT_TO" VARCHAR2(3"
"0), "DOC_STORAGE_TYPE" VARCHAR2(1), "ORIGINAL_FILE_NAME" VARCHAR2(100), "NE"
"W_FILE_NAME" VARCHAR2(30), "SAVED_DRIVE_LETTER" VARCHAR2(3), "SAVED_DIRECTO"
"RY" VARCHAR2(50), "FULL_PATH" VARCHAR2(100), "FILE_DETAILS" VARCHAR2(100), "
""TEMPLATE_NAME" VARCHAR2(30)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25"
"5 LOGGING STORAGE(INITIAL 196214784 NEXT 1540096 MINEXTENTS 1 MAXEXTENTS 99"
"9 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPA"
"CE "ASCLEPIOS_DATA""
IMP-00003: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [[ktfbbsearch-7]], [[125]], [[]], [[]], [[]], [[]], [[]], [[]]

Report message to a moderator

Re: Import from 8i to 9i - ORA-00600 [message #59401 is a reply to message #59393]

Mon, 17 November 2003 05:14

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

it is a reported bug.
the error only applies to locally managed tablespaces trying  to create an initial extent greater than 63M when using a non standarad block  size (i.e not 4k,8k,16k,etc..) . 
workaroud is to use a standard block size of 8192 or something like that with locally managed tablespaces.

Report message to a moderator

Previous Topic:	Background processes
Next Topic:	v$session view

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:23:56 CDT 2024