Re: EXP INCTYPE problem in ORACLE7
Date: Thu, 26 Aug 1993 12:48:45
Message-ID: <930826124845_at_dlpc030.dlogics.com>
In article <1993Aug25.072954.1_at_corp02.d51.lilly.com> jl34778_at_corp02.d51.lilly.com writes:
> I am running ORACLE 7.0.13 on VMS 5.5-2 and am having a problem with using the
> INCTYPE parameter with EXP...
> I get the following error at the end of the export.
>
> . about to export _NEXT_USER's tables ...
> EXP-00008: ORACLE error 1 encountered
> ORA-00001: unique constraint (SYS.I_INCEXP) violated
> EXP-00000: Export terminated unsuccessfully
>
The user authorization tables are out of sync. _NEXT_USER is a fake
user id which corresponds to the next id number to be assigned when a new
user id is created. There should never be any database objects owned by the
id value _NEXT_USER, nor is there any normal way to create such objects.
Perhaps a database install was aborted and restarted. I think the solution
may require diddling with the user tables directly, to increase the value
of the _NEXT_USER id number; and manual creation of a user with the old
value of _NEXT_USER; this must be followed by a shutdown/startup. If you
are just playing with a new v7 install, i would re-create the db.
-- Dave Mausner / Sr Consultant / Datalogics division of Frame Technology Inc 441 W Huron / Chicago IL 60610 / +1-312-266-4450 / "Just show me the code"Received on Thu Aug 26 1993 - 12:48:45 CEST