Re: ORA-00904

This error happens when your export/import catlog is not in sync with the latest data dictionary.

Run catexp.sql ( or catexp7.sql ) catalog files and retry the export.

Let me know if it worked.

Hope this helps,

Manoj Jain
Oracle Certified Professional - DBA
Chauncey Certified Oracle7 DBA

In article <35e0817e.0_at_news1.ibm.net>,
  <gm1_at_ibm.net> wrote:
> I tried exporting an application system but it keeps failing. I get the
> following in my log file :
> About to export specified tables via Conventional Path ...
> . . exporting table XT_APPLICATION 1 rows exported
> . . exporting table XT_CIUE_ASSOCIATION_TYPES 0 rows exported
> . . exporting table XT_CIUE_ELEMENT_TYPES 0 rows exported
> . . exporting table XT_CIUE_PROPERTIES 0 rows exported
> . . exporting table XT_CIUE_TEXT_TYPES 0 rows exported
> . . exporting table XT_CIUE_TEXT_USAGES 0 rows exported
> . . exporting table XT_RM_TEXT_LINES 37 rows exported
> . . exporting table XT_SDDV_DIAGRAM_SEGMENTS 407 rows exported
> . . exporting table XT_SDDV_ELEMENTS 354 rows exported
> . . exporting table XT_SDDV_STRUCTURE_ELEMENTS 525 rows exported
> . . exporting table XT_APPLICATION_LOGIC 0 rows exported
> EXP-00008: ORACLE error 904 encountered
> ORA-00904: invalid column name
> EXP-00000: Export terminated unsuccessfully
>
> Can anyone explain this error message to me and how I can correct any errors
> so that I can export my application?
> Thank You
> Glenn Malar
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 24 1998 - 01:04:28 CDT