Re: EXP73 and ORA-1003 error.
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 exportedWhat are the versions - in 5 decimals, please?
from a different database.
I can query the data and the row counts areOne of the export views is missing - I know there has been a change in the
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.
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 withoutIf running RDBMS V8, run catexp7 as well against the 8 instance - view names
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?
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