Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> export error - identifying cause
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
![]() |
![]() |