We just upgraded our server from Windows NT / Oracle 8.15
to Windows 2000 / Oracle 8.17 + Patch. After loading the
database I attempt to Export our newly configured database and receive
the following error : EXP-00008 Oracle error 904 encountered
ORA-00904 invalid column name
EXP-00000 Export terminated unsuccessfully
I just set the Oracle_Sid = New_Sid and navigated to full
path of EXP.exe and still encounter the same problem.
The machine was wiped clean before OS/Oracle re-install.
No prior EXP.exe should exist. Any other suggestions ?
I also ran Catexp.sql as suggested. This encountered many
errors. " Insufficient privleges" "Table or View does not exist".
I ran with a super user created with Sysdba provleges.
Somehow my "internal" user is gone .. How to re-create ?