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: problem with exp utility when called remotely

Re: problem with exp utility when called remotely

From: rince <david.uhlik_at_seznam.cz>
Date: 10 Aug 2001 03:05:20 -0700
Message-ID: <9d049dd4.0108100205.3a283b79@posting.google.com>

I don't think that is the problem. I tried to run exp user/pass_at_connect_string localy with hostname = localhost. So exp and server are the same version. And the same problem occur. So maybe it's Net8 problem.

get4ked_at_yahoo.com (Ford) wrote in message news:<b2b9197f.0108091051.3cf6ae1_at_posting.google.com>...
> Problem is you're using a later version of export 817 against an older
> database 816 - you'll need to upgrade the server to 817.
>
> david.uhlik_at_seznam.cz (rince) wrote in message news:<9d049dd4.0108090512.7e37058e_at_posting.google.com>...
> > I have problem with exp utility. I have export script which work fine
> > when called on Oracle server computer. It's ok when we have
> > application server on the same computer as database server. But
> > sometimes we use another configuration. One computer as app server and
> > another as db server.
> > The problem is on second configuration.
> > We have to make backup before one operation. We have to call exp from
> > Java application. Locally it's ok but remotely we have to use exp
> > user/pass_at_connection_string syntax. And that's the problem. Export
> > fails.
> >
> > Here is text from console:
> >
> > Export: Release 8.1.7.0.0 - Production on Mon Aug 6 01:30:20 2001
> >
> > (c) Copyright 2000 Oracle Corporation. All rights reserved.
> >
> >
> > Connected to: Oracle8i Release 8.1.6.0.0 - Production
> > JServer Release 8.1.6.0.0 - Production
> > Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR
> > character set
> >
> > About to export specified users ...
> > . exporting pre-schema procedural objects and actions
> > . exporting foreign function library names for user GK
> > . exporting object type definitions for user GK
> > About to export GK's objects ...
> > . exporting database links
> > . exporting sequence numbers
> > . exporting cluster definitions
> > . about to export GK's tables via Conventional Path ...
> > . . exporting table ADR_INFOTEXT
> > EXP-00008: ORACLE error 904 encountered
> > ORA-00904: invalid column name
> > . . exporting table ADR_KUNDEN
> > EXP-00008: ORACLE error 1003 encountered
> > ORA-01003: no statement parsed
> > . . exporting table ADR_VERWEIS
> > EXP-00008: ORACLE error 904 encountered
> > ORA-00904: invalid column name
> > . . exporting table ARCHIVE_BONKOPF
> >
> >
> > My friend tested it on the same configuration on his system and
> > realized the same fault. So the problem is probably on Oracle side.
> > Have you seen this problem? Or even solved it? Is there any way to
> > call exp from Java more effectively(script, method on server)? If so
> > please tell me.
> >
> > Thanks
> >
> > David
Received on Fri Aug 10 2001 - 05:05:20 CDT

Original text of this message

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