Re: Export problem ORA-00904.

Thanks

FYI - Turns out the problem caused by failure or rmjvm.sql to complete when trying to remove the Java VM .
Consequently some Java VM objects are left in the database causing the invalid column name problem.
This is fixed by editing the rmjvm.sql script to change "call rmjvm.run(true)" to "execute rmjvm.run(true)." After this the export works fine.

Regards

Ray

"Peter van Rijn" <p.vanrijn_at_rm-this.zhew.nl> wrote in message news:ujq2i4m3s0eg60_at_corp.supernews.com...
> Check Note 148048.1 on Metalink. It describes cause and workaround.
>
> hth,
> Peter
>
>
> "Ray Teale" <ray_at_BLAHholly.com.au> schreef in bericht
> news:tu6%8.5236$Cq.235076_at_ozemail.com.au...
> > Oracle Release 8.1.6.0.0
> >
> > Removed Java VM from the installation using "rmjvm.sql" because of SGA
> > problems.
> >
> > Performing full db export gives me this message ......
> >
> > . exporting referential integrity constraints
> > . exporting synonyms
> > EXP-00008: ORACLE error 904 encountered
> > ORA-00904: invalid column name
> > EXP-00000: Export terminated unsuccessfully
> >
> > Reinstalled Javavm by running "initjvm.sql" - problem goes away.
> >
> > Any ideas why?
> >
> > Regards
> >
> > Ray
> >
> >
>
>
Received on Tue Jul 30 2002 - 01:37:54 CDT