Re: Export problem [urgent help]

The export views changed in version 8, your v8 tools is trying to query columns and tables that simply dont exist in v7, I have no idea if you can run the v8 views against a v7 database so investigate this as an option. Failing that , install a v7 home on the client P.C. and use the v7 export tool.

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:399db8b6$1_at_news.iprimus.com.au...
>
> <gopdiv_at_my-deja.com> wrote in message news:8ngt2a$snn$1_at_nnrp1.deja.com...
> > Hi All,
> >
> > I have a question , My server has oracle 7.3.4 database and my PC
> > has client 8.0.5 with export utilities. I am facing a problem on export
> > when I use exp80 system/manager_at_alias to export the 7.3.4 database into
> > my PC , it gives me errors as below . Please advice on how to go about
> > doing this right.
> >
> > EXP-00008: ORACLE error 942 encountered
> > ORA-00942: table or view does not exist
> > EXP-00024: Export views not installed, please notify your DBA
> > EXP-00000: Export terminated unsuccessfully
> >
> > Thanks in advance
> >
> > Thanks,
> > With kind regards
> >
>
> The rather counter-intuitive rule is that a high version of export cannot
> reliably be applied to a low version database. So 8.0 export won't work
 on
> a 7.x database.
>
> It *does* work the other way round (ie, 7.x export can be applied to an
 8.x
> database), though you can't export things which make use of new version
> features (LOBS, for example). You end up with a version 7 dump file.
>
> Seems odd to me (small matters of backward compatibility spring to mind),
> but that's the way of things!
>
> You need to get hold of the version 7 executables.
>
> Regards
> HJR
>
>
>
>
>
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Fri Aug 18 2000 - 19:40:20 CDT