Re: EXP73 and ORA-1003 error.

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Mon, 12 Apr 1999 13:29:19 +0200
Message-ID: <3711D90F.A9323BB9_at_vnl.nl>


Daniel Recio wrote:
I have created a new instance and populated it by importing data exported
from a different database.
What are the versions - in 5 decimals, please?
I can query the data and the row counts are
correct, but when I try to export this new database I get errors for each
table.

        ORA-01003: no statement parsed

I'm trying to use the 'exp73' command line utility to export from an Oracle
7.3.2 database running on Novell 4.10.  I start out the export by
typing 'exp73' on the command line and then fill in all of the parameters
that it requests.  I tell it to export the entire database. (I have tried it
with a param file too)

It goes through the first few portions of the export then it gets a problem:
namely 'EXP-00008: ORACLE error 1003 encountered'; then 'ORA-01003: no
statement parsed'.  These same two messages are shown for each table - even
though it does give me statistics on how many rows are exported for each
table.

Then, at the end of the export, I get the messages:
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully.

One of the export views is missing - I know there has been a change in the
views betweeen 7.2 and 73 (or perhaps 7.3.2 and 7.3.3?).
That implies you cannot use the exp73 tool for another version, than the RDBMS
it came with.
The scripts CATALOG, CATPROC and CATEXP have been executed many times without
any soluction.

What am I doing wrong to get these messages?  What statements aren't getting
parsed and how can I find out what the invalid column name is?
 

If running RDBMS V8, run catexp7 as well against the 8 instance - view names
have changed, so you can use exp80 and exp73 against it.
Similar, you can run catexp for v8 against a v7.3 instance.
--
Frank van Bortel

Technical Consultant Oracle
V&L Informatica BV
-------------------------------------------------
Work                                Home
Postbus 545                         Hunzestraat 4
7500 AM Enschede                    7555 WB Hengelo
(31)53.434.1500                     (31)74.242.5046
  Received on Mon Apr 12 1999 - 13:29:19 CEST

Original text of this message