Re: Cant export database! HELP!

In article <khuisman.56.000915FD_at_wnet.gov.edmonton.ab.ca>, khuisman_at_wnet.gov.edmonton.ab.ca (Ken Huisman) wrote:
>
> We just upgraded our netware oracle to 7.0.16.6.0 from 7.0.15 and now we
> cannot do an export! When we try to export the entire database, we get this
> error when it gets to exporting roles:
>
> .exporting roles
> EXP-00008 ORACLE error 904 encountered
> ORA-00904: invalid column name
> EXP-00222: System error number 2
> System error message: No such file or directory
>
>
> and then it terminates. This happens if I run exp from the netware console
> or from a PC over sqlnet. Has anyone else run into this problem? What do you
> do to fix it?
>
> thanks.
>
> Ken
>
> khuisman_at_wnet.gov.edmonton.ab.ca

Ken,

This is a common problem when encountered when upgrading Oracle. You upgraded the rdbms AND exp. The new version of exp is looking for slightly different views then 7.0.15 was using. ?/rdbms/admin/catexp.sql will drop and recreate the exp views and usually take care of the problem.

If you are still having problems add the following line to your init.ora and restart the instance.
event="904 trace name errorstack"

That will cause a trace file to be created whenever a process generates a 904 error. (this event works for any ORA- error) Now try exporting again. When you recieve the 904 error check the USER_DUMP_DEST directory for a new trace file. The trace should show you the actual table or view that has the invalid column. Search ?/rdbms/admin/*.sql to find out where this table/view is created.

Steve Hoffman Consulting at Apple Computer Received on Tue Jan 24 1995 - 18:13:23 CET