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: Ford <get4ked_at_yahoo.com>
Date: 10 Aug 2001 13:12:19 -0700
Message-ID: <b2b9197f.0108101212.3c1764f7@posting.google.com>

try re-running catexp.sql

david.uhlik_at_seznam.cz (rince) wrote in message news:<9d049dd4.0108100205.3a283b79_at_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 - 15:12:19 CDT

Original text of this message

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