Re: export aborts with error 904

mabman1_at_my-deja.com wrote:
>
> 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...

Make sure that the "exp" version is suitable for your database. Normally this means: is the same version.

Unfortunately exp takes _a_lot_of_ assumptions about the data dictionary.

Uwe

-- 
Uwe Schneider - WEB.DE AG - Amalienbadstr. 41 - 76227 Karlsruhe 
Forschung & Entwicklung - Tel. (+49) 721 94329 832
"In a world without walls and fences, who needs windows and gates?"