Re: Horrible export error

In article <iordonez-1004950001120001_at_slip1-40.acs.ohio-state.edu>, iordonez_at_magnus.acs.ohio-state.edu says...
>
>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
>
>--
>Ivan Ordonez
>iordonez_at_magnus.acs.ohio-state.edu
>http://www.cis.ohio-state.edu/~iordonez

I've had this problem when the export views were out of date. Check your catexp.sql script.

/Wilhelm Olander Received on Mon Apr 24 1995 - 00:00:00 CEST