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: export error - identifying cause

Re: export error - identifying cause

From: Pavel Polcar <pavel.polcar_at_berit.cz>
Date: 18 Aug 1998 14:12:20 GMT
Message-ID: <01bdcab2$3a8b2970$504331c3@polcar_nt4006>


Hi,
just an idea. What about versions of exp utility and Oracle Server? Hth,
Pavel

Fred Pierce <fpierce_at_avialantic.com> wrote in article <35D97C9C.D5910956_at_avialantic.com>...
> Wondering if anyone has any tips on identifying the column or trigger
> causing this error, or even if it really means the error is associated
> with a trigger - seems so but these things can be misleading:
>
> . exporting referential integrity constraints
> . exporting triggers
> EXP-00008: ORACLE error 904 encountered
> ORA-00904: invalid column name
> EXP-00000: Export terminated unsuccessfully
>
> Thus far I can't find any problems in the database - recompiled the
> triggers, no errors. I know it says somewhere, but does compilation
> check column referances, i.e. will it compile succesfully while
> referencing an invalid column? Tried a dif between create scripts of the
> development and prod databases, but so many other changes it's pretty
> useless.
>
Received on Tue Aug 18 1998 - 09:12:20 CDT

Original text of this message

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