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

export error - identifying cause

From: Fred Pierce <fpierce_at_avialantic.com>
Date: Tue, 18 Aug 1998 13:10:17 GMT
Message-ID: <35D97C9C.D5910956@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 - 08:10:17 CDT

Original text of this message

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