Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Import Problem

edited Jun 17, 2014 12:00PM in Database Install/Upgrade/Opatch (MOSC) 2 commentsAnswered

Hello, I'm a newbie.

I installed 12.1.0.1.0.

I imported my schema from Oracle 9i to 12c and these are the errors I received.

what seems to be the problem, pls help. thank you.

. . importing table             "STUD_ADDRESS"  37329 rows imported

IMP-00017: following statement failed with ORACLE error 600:

"CREATE UNIQUE INDEX "STUD_ADDRESS_PK" ON "STUD_ADDRESS" ("STUDENT_ID" , "AD"

"DRESS_DATE" , "TYPE" , "STATUS" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORA"

"GE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING"

IMP-00003: ORACLE error 600 encountered

ORA-00600: internal error code, arguments: [smboPut:fixedlen2], [1], [7], [1], [15843], [], [], [], [], [], [], []

IMP-00017: following statement failed with ORACLE error 20000:

"BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"STUD_ADDRESS_PK"',NULL,NULL,NULL,3"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center