Re: Export problem after applying Patchset to Oracle 9i

tolga toonja wrote:
> 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

Look at the script. Drop all the objects it creates, that are owned by SYSTEM. Rerun as SYS.

Frank Received on Tue Jan 14 2003 - 20:11:47 CET