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

-----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



Oracle LazyDBA home page