Re: Horrible export error

iordonez_at_magnus.acs.ohio-state.edu (Ivan Ordonez) writes:
: I am trying to export a user from an Oracle database. We have two
: databases, called D and P; I have succesfully done this procedure for D,
: but when I try it in P, the following happens. Any ideas? Thanks in
: advance.
:
: --Ivan Ordonez
: ----------------------------
: Connected to: ORACLE7 Server Release 7.0.16.6.0 - Production
: With the procedural and distributed options
: PL/SQL Release 2.0.18.1.0 - Production
: Enter array fetch buffer size: 4096 >
:
: Export file: expdat.dmp >
:
: (2)U(sers), or (3)T(ables): (2)U >
:
: Export grants (yes/no): yes >
:
: Export table data (yes/no): yes >
:
: Compress extents (yes/no): yes >
:
: About to export BTRC's objects ...
: . exporting snapshots
: . exporting snapshot logs
: . exporting database links
: . exporting sequence numbers
: . exporting cluster definitions
: . exporting stored procedures
: EXP-00008: ORACLE error 904 encountered
: ORA-00904: invalid column name
: EXP-00222:
: System error message
: EXP-00000: Export terminated unsuccessfully
:

Run ?/rdbms/admin/catalog.sql

while connected to SQL*Plus as SYS.

--
regards,
Carl
+-----------------------------------------------------------------------------+
Carl Gohringer, Oracle European Development Centre, World Wide Education 
Oracle Park, Bittams Lane, Chertsey, Surrey, England, KT16 9RG
Internet   : cgohring_at_uk.oracle.com    
+-----------------------------------------------------------------------------+