Export from Sun to access Linux!?

From: <ibm_97_at_yahoo.com>
Date: Mon, 17 Jan 2000 16:35:39 GMT
Message-ID: <85vgcq$fh8$1@nnrp1.deja.com>

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. Received on Mon Jan 17 2000 - 10:35:39 CST