Re: imp fails after upgrade

Randy Harris wrote:

>I manage an application that uses an Oracle DB. That DB resides on a host
>running 8.1.7.3 on HP-UX 11.00. Since I don't have access to that system
>and I am not confident that it is being backed up reliably, I have been
>doing a nightly export from another system, run from a cron (my local Oracle
>server). That has been working fine for some time.
>
>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?
>
>
>

First:

SELECT object_name
FROM dba_objects
WHERE status = 'INVALID';

I expect you'll find some. Then check the log file from the upgrade. Then repeat the upgrade.

Make sure you perform any STARTUP MIGRATE or other recommendations that are in the documentation
and be sure to run utlrp.sql in the /rdbms/admin directory.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)