ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dhirendra Kulkarni" <dkulka...@ptc.com>
Subject Re: how to export data
Date Fri, 19 Oct 2001 06:19:24 GMT
Ok Thanks, I am tring <exec> task

----- Original Message -----
From: Erik Hatcher <jakarta-ant@ehatchersolutions.com>
To: <ant-user@jakarta.apache.org>
Sent: Friday, October 19, 2001 4:08 PM
Subject: Re: how to export data


> <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" <dkulkarni@ptc.com>
> To: <ant-user@jakarta.apache.org>
> 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
>
>
>
>


Mime
View raw message