Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export from Sun to access Linux!?
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
![]() |
![]() |