Re: export error - identifying cause

From: Joel Garry <joelga_at_pebble.org>
Date: Tue, 18 Aug 1998 18:45:12 GMT
Message-Id: <slrn6tjiuu.aa8.joelga@pebble.org>

On Tue, 18 Aug 1998 13:10:17 GMT, Fred Pierce <fpierce_at_avialantic.com> wrote:
>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.

I've gotten this error when I've forgotten to run the $ORACLE_HOME/rdbms/ admin/cat7* script after an upgrade. Or some mistake like that.

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Tue Aug 18 1998 - 13:45:12 CDT