Re: Q: Exp delivers error messages

A copy of this was sent to Uwe Schneider <uwe.schneider_at_xlink.net> (if that email address didn't require changing) On Thu, 28 Oct 1999 17:40:29 +0200, you wrote:

>Hi,
>
>When exporting an Oracle 7.3.3 user's DB objects I will always get the
>following error messages:

have you upgraded this database? did you run catexp.sql after the upgrade?

>
>> exp CONSISTENT=Y FILE=aradmin.dmp LOG=exp.log
>
>Export: Release 7.3.3.0.0 - Production on Thu Oct 28 17:35:49 1999
>
>Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
>
>Username: aradmin_at_wg7n
>Password:
>
>Connected to: Oracle7 Server Release 7.3.2.2.0 - Production Release
>With the distributed option
>PL/SQL Release 2.3.2.2.0 - Production
>Export done in WE8ISO8859P1 character set
>About to export ARADMIN's objects ...
>. exporting snapshots
>. exporting snapshot logs
>. exporting job queues
>. exporting refresh groups and children
>. exporting database links
>. exporting sequence numbers
>. exporting cluster definitions
>. about to export ARADMIN's tables via Conventional Path ...
>. . exporting table ACTLINK 265 rows
>exported
>EXP-00008: ORACLE error 904 encountered
>ORA-00904: Ungultiger Spaltenname
>. . exporting table ACTLINK_DDE 0 rows
>exported
>EXP-00008: ORACLE error 1003 encountered
>ORA-01003: keine Anweisung wurde analysiert/geparst
>. . exporting table ACTLINK_GROUP_IDS 5060 rows
>exported
>EXP-00008: ORACLE error 1003 encountered
>ORA-01003: keine Anweisung wurde analysiert/geparst
>. . exporting table ACTLINK_MACRO 49 rows
>exported
>EXP-00008: ORACLE error 1003 encountered
>ORA-01003: keine Anweisung wurde analysiert/geparst
>. . exporting table ACTLINK_MACRO_PARM 99 rows
>exported
>
>
>... and so on. It seems that all objects are contained in the dump file
>but I am wondering what the error messages mean. I guess the ORA-1003
>message is a consequence of the ORA-904 at the beginning.
>
>Can you help me?

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Oct 28 1999 - 10:55:06 CDT