Migration (exp/imp) ORA-006000

Hello All,

I've got an ORA-600 during an import. Can anyone help me out?
(Platform= SGI IRIX 6.5)

I exported a user's objects from the original 7.3.3 database thus:

exp sys/change_on_install owner=username1 file=expat.dmp log=export1.log

All the original users' objects were in a single tablespace "USERS". He owned some tables, indexes, sequences and a procedure

I have created a new 8.0.5 database with a DATA tablespace and 2 RBS
(extra to the usual system one), ran catalog & catproc etc etc. In this
database I have created a new user (username2) and granted him RESOURCE role and CREATE session privileges.

I change the ORACLE variables in my UNIX environment and then.. I run import like this:

imp sys/change_on_install destroy=n ignore=y file=expat.dmp fromuser=username1 touser=username2 log=import1.log

On 2 tables (one of which I believe is a copy of the other) I get an IMP-00017, IMP-00003 and an ORA-00600 error. This is when Import tries to create the primary key on these 2 tables. Could it be because of the storage clause? Or is it because my username2 doesn't have the create index privilege? (incidentally, I don't think it is that, because it creates other indexes fine...).

Needless to say, my indexes aren't present, which I guess is easily remedied. I just wondered if anyone had any idea why they aren't...

Thanks in advance,

Sarah Received on Thu Feb 03 2000 - 09:20:32 CST