Re: Export from Sun to access Linux!?

It appears that your export views are not installed. Have you run catexp.sql from $ORACLE_HOME/rdbms/admin?

Cheers,
GC

In article <85vgcq$fh8$1_at_nnrp1.deja.com>,   ibm_97_at_yahoo.com wrote:
> A box: oracle 8i for solaris
> B box: oracle 8.0.5 for Linux on Red Hat 6.0
>
> Since there's not enough space in B, I want to export a big table in B
> box to box A.
>
> I create a entry in 'tnsnames.ora' file on box A. Using 'sqlplus' to
> connect B from A has no problem at all. But when I try to do the
export
> as following:
>
> exp <user>/<pass>@<entry_of_B> file=<...> tables=<...> direct=y
>
> The error message I got is:
>
> exp-00008: ORACLE error 942 encountered
> ora-00942: table or view doesn't exist
> exp-00024: export views not installed, please notify your DBA
> exp-00000: export terminated unsuccessfully.
>
> What's wrong? And I can do 'export' in box B (test on some smaller
> tables). Incompatiable?
>
> Please give me some suggestion! Thanks!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 17 2000 - 12:27:36 CST