Re: imp fails after upgrade

On Sat, 11 Oct 2003 20:27:40 GMT, "Randy Harris" <randy_at_SpamFree.com> wrote:

>Yesterday I upgraded my local server to 8.1.7.4. Now I can longer do a full
>export. I get this error
>
>. exporting sequence numbers
>EXP-00008: ORACLE error 904 encountered
>ORA-00904: invalid column name
>EXP-00000: Export terminated unsuccessfully
>
>It seems to work OK until it begins exporting the sequence numbers. I was
>able to confirm that a "exp full=yes" can be done successfully on the
>8.1.7.3 system. What is the cause of this and what, if anything, can I do
>to correct it?

The usual issue of not running
catalog.sql
catproc.sql
----> catexp.sql
after every upgrade
though these steps are documented.

--
Sybrand Bakker, Senior Oracle DBA