ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dhirendra Kulkarni" <dkulka...@ptc.com>
Subject how to export data
Date Fri, 19 Oct 2001 05:48:22 GMT
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