Either put it all on one line or into a parfile.

-----Original Message-----
From: Jim Thomas
[mailto:oracledba-ezmlmshield-x83631657.[Email address protected]
Sent: Tuesday, January 08, 2008 1:35 PM
To: LazyDBA Discussion
Subject: Please help-I am getting error on execution

Hi,

I am running 8.1.7.4 in HP-UX and I am trying to update a table using an
export file

it was exported by finpilot but I am importing it to finprod-



The error I am getting is ./impt.bat[2]: Syntax error at line 2 : `(' is
not expected.



the import line is such:



imp sys/support fromuser=finpilot touser=finprod
file=sales_tables_before_migration_backup.dmp
tables=(sales_order_headers) query=where customer_number=62 ignore=y
indexes=n logfile=impt.log

~



Could anybody please help?



Thank You

Jim Thomas



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


______________

The information contained in this message is proprietary and/or confidential. If you are not the
intended recipient, please: (i) delete the message and all copies; (ii) do not disclose,
distribute or use the message in any manner; and (iii) notify the sender immediately. In addition,
please be aware that any message addressed to our domain is subject to archiving and review by
persons other than the intended recipient. Thank you.
_____________

Oracle LazyDBA home page