Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Migration (exp/imp) ORA-006000

Re: Migration (exp/imp) ORA-006000

From: s. hunter <sarahxhunter_at_NOSPAMTHANX.hotmail.com>
Date: Thu, 03 Feb 2000 17:17:53 +0100
Message-ID: <3899AA31.4B7C3A48@NOSPAMTHANX.hotmail.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US