Export problem after applying Patchset to Oracle 9i

From: tolga toonja <tolgatoonja_at_yahoo.com>
Date: 14 Jan 2003 01:51:04 -0800
Message-ID: <857fe98f.0301140151.d421f92_at_posting.google.com>


I had some problems with oracle 9i and I applied the PatchSet 9.0.1.4 to Oracle 9i and those problems gone. But then an export problem arose. Export ends with the problem:

EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully

And then a person from Oracle Partnership told me to run the catexp.sql where it locates in the %ORACLE_HOME%/rdbms/admin directory as the sys user. Problem was sold in our database. But by mistake I ran the sql as a system user instead of sys user in a client's database.
Now in the client's DB; When I try to export, It locks in the first table with no error message.

What should I do best now?
Any help or info is greatly appreciated!

Tolga

PS. I tried to make an export in the server as the system user, and as an other user with grant "exp_full_database" and other neccessary grants.
Platform: Win2000, oracle 9i Received on Tue Jan 14 2003 - 10:51:04 CET

Original text of this message