ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Erik Hatcher" <jakarta-...@ehatchersolutions.com>
Subject Re: how to export data
Date Fri, 19 Oct 2001 10:38:33 GMT
<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