Hi Dhirendra,
As far as I understand "export" is an executable not an SQL statement, so one shouldn't expect it to work anyways. I suggest that you use use the "exec" task in place of the "sql" task for the same.
Regards
_____________________________________
Kapil Singh Pawar
Consultant - Integration
i2 Technologies India Private Ltd.
1 Primrose Road
Bangalore 560 025, INDIA
Email: [EMAIL PROTECTED]
Tel: +91 80 558 1487-90 ext. 2416
| "Dhirendra Kulkarni" <[EMAIL PROTECTED]>
10/19/01 11:18 AM
|
To: <[EMAIL PROTECTED]> cc: 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=""> 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
