EXP-00008: ORACLE error 904 encountered

[greenpee]

Hi,

I am trying to export one table from live box to my testing box. Both boxes are Sun boxes. Oracle on both machines are the same 8.1.7. I have no problem to export and import on each locally and transfer dmp file to another and get imported. But I have problem when I export directly from one machine to another

About to export specified tables via Direct Path ...
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully

 

[karluk]

Your errors are symptomatic of an export utility that doesn't match the database version you are exporting from. So, despite the fact that you are confident that the dbs are both 8.1.7, that is probably the source of your problem. I would check not only that the release is 8.1.7, but also the specific patch level that you are at.