ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kapil_Pa...@i2.com
Subject Re: how to export data
Date Fri, 19 Oct 2001 10:37:14 GMT
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: kapil_pawar@i2.com
Tel: +91 80 558 1487-90 ext. 2416




"Dhirendra Kulkarni" <dkulkarni@ptc.com>
10/19/01 11:18 AM
Please respond to ant-user

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