I have migrated an Oracle 8i DB (8.1.5) to a new build of Oracle 9i (9.2.04) by importing and exporting the dump file from the 8i DB. Everything works fine on my new 9i DB apart from the exp utility. If I try and export "users" I get these errors: "Exp-00056:ORACLE error 31600 encountered" and "ORA-06512."
I understand that I may have to run the catpatch.sql script to see if this will resolve the issue, but I'm cautious because I would like to back up the DB before running the SQL script. What would be the best way to back up before running the script?
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.