Re: export aborts with error 904

Your export views are out of date or missing. Run %ORACLE_HOME%|$ORACLE_HOME/rdbms/admin/catexp.sql by using svrmrgl or sqlplus. You need to be connect as internal|sys.

Hth,

Sybrand Bakker, Oracle DBA

<mabman1_at_my-deja.com> wrote in message news:8naf8k$423$1_at_nnrp1.deja.com...
> Hi. I've just started to experiment with Oracle 8i (with the assistance
> of Arsdigita docs - www.arsdigita.com). The database is installed, and
> a sample database has been created (nothing in it as yet). I'm trying
> to do an export, but I keep getting the following error:
> <snip>
> - about to export MABMAN's tables via Direct Path
> - exporting synonyms
> EXP-00008: ORACLE error 904 encountered
> ORA-00904: invalid column name
> EXP-00000: export terminated unsuccessfully
>
> It's being run from a script that basically sets a few variables, such
> as ORACLE_HOME. I've also altered the command path to set direct=N
> (...via Conventional Path), but this makes no difference in the error.
>
> Any ideas as to how to fix this? Someone posted the same thing on
> ArsDigita's bulleting board a little while ago and no one posted a
> response....
>
> Thanks,
> Glenn
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Aug 15 2000 - 00:32:52 CDT