Ok Thanks, I am tring <exec> task ----- Original Message ----- From: Erik Hatcher <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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 > > > >
