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?

Do ya thunk it's possible that a 8.1.7.4 export executable might not be compatible with a 8.1.7.3 export dictionary? What's metalink/support say? (or perhaps the upgrade docco that comes with the upgraded s/w?)

One possibility - install a baseline 8.1.7.3 (no need to install a database -just the s/w) in a separate Oracle Home on your local machine. Use that instead of the new s/w to continue your exports.

A second possibility - shake some trees to ensure the backups on the HP are done properly so you don't end up being responsible for things you really can't control. (What happens when 'they' upgrade the HP-UX?)

A third - there's a reason for upgrading to 8.1.7.4 .... have the DB on the HP-UX machine upgraded.

A fourth - get all the databases moved up to 9i

A fifth - investigate RMAN for backup.

(etc., etc., etc.)

-- 
/Hans
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]