Printable View
I have an 8.1.6 database patched to a 8.1.6.3.8. The database seems happy while it is running, but when I do an exp I get two errors
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
Please help!
Have you rerun catalog/catproc since patching the database?
Regards
Yes I did. I just ran them again to be sure. I did another export and got identical errors.
try running catexp.sql (i know its included in the catalog.sql)
and spool the output and see if any signnificant error is there.
How are you doing this export?
Are you uing command line, parfile?
MH
Actually I did run catexp.sql too - I tried that first.
I am running a .bat file - I use this same format on all of the other servers and it works beautifully.
D:
set oracle_sid=sid
cd Oracle\admin\sidname\exp
exp username/password file=username.dmp log=username.log
is this a full or user level export
It's both. I just put the user .bat in the last reply but I do a full also and get the same errors.
Can you run this manually with a parfile?
Try it with ROWS=N
MH
Didn't make a difference. I am trying right now on a test server I have that is currently having the same problems. It was loaded at the same time.