<sql> is for executing SQL statements. 'exp' is a command-line utility not
a SQL statement. Use the <exec> task to execute command-line utilities.
Erik
----- Original Message -----
From: "Dhirendra Kulkarni" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 1:48 AM
Subject: how to export data
Hi all,
Iam trying to export data from oracle database for particular user through
Ant. my build.xml is
<target name="exptest" >
<sql
driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@armada:1521:wind"
userid="wtadmin"
password="wtadmin"
src="data.sql"
print="yes"
/>
</target>
and statement in data.sql file is
exp file='test.dmp'
iam getting error saying that it is invalid statement. Actually if run this
command in DOS
exp wtadmin/wtadmin file=test.dmp
it is successfully exporting the database. Also if i type same command in
sqlplus, then also iam getting invalid statement. So how do i export data.
Please help
Thanks
DK
