Re: imp fails after upgrade

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:nbohov0jfsq3jqgki1gao0ge64tkpi5g4f_at_4ax.com...
> 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.

Please correct me if I'm wrong. I thought those would only be run after upgrading a databse? I ran them on all of my local databases (after upgrading the server to 8.1.7.4), but the databse I'm having a problem with is still at 8.1.7.3.

> Sybrand Bakker, Senior Oracle DBA
Received on Sun Oct 12 2003 - 01:07:15 CDT