Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Migration (exp/imp) ORA-006000
Yvan Galas wrote:
> "s. hunter" wrote:
> >
> > 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...).
>
> Hi,
>
> ORA-600 means call oracle support.... ;)
> If you can export your old database without any data (rows=n) and import
> it in your new database
> and after export with data and import it again
>
> Ps : it's not privilege problems cause it's sys user who's create the
> objects...
Yeah, I know......! =?)
But I was kind of hoping that someone here might have had a similar problem.
I thought it might be a privileges problem because I tried doing the import
when the Username2 just had create session and it wouldn't let me!
Received on Thu Feb 03 2000 - 10:17:53 CST