Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Export from Sun to access Linux!?

Re: Export from Sun to access Linux!?

From: <ibm_97_at_yahoo.com>
Date: Mon, 17 Jan 2000 19:17:04 GMT
Message-ID: <85vpr2$n5n$1@nnrp1.deja.com>


I re-run this script, still got the same error. But BTW, how do u explain that I can run 'export' successfully in local box B even before I re-run the script?

Thnx

In article <85vmu2$ksj$1_at_nnrp1.deja.com>,   MGC <gconron_at_zdnetmail.com> wrote:
> 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.
>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US