Hi

ahh well you should try put your query /where clause
in your parameter file and try to do the export..

put your where calsue in a paramter file..

or on windows

C:\exp>exp userid=scott/tiger tables=emp
query="""where sal < 100"""


on unix

exp userid=/ tables=emp query=\"where sal \< 100\"


regards
Hrishy



--- Varsha Savyasachi <[Email Address Removed] wrote:
> hi all,
>
> I get a ORA 904 error when I run an export of tables
> with a query in a 816
> db. I also ran the catexp.sql, and re-tried the
> export but to no avail.
>
> Any ideas?
>
> thanks,
>
> Varsha Savyasachi
>
>

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
Oracle LazyDBA home page