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="" 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 alsoiam getting invalid statement. So how do i export data. Please help Thanks DK
RE: how to export data
Dhirendra, Please don't post html mail to the list. The fact that sqlplus says that the statement is invalid means that this is an oracle question, rather than an ant question. I suggest that you ask the question in a more appropriate forum. Will -Original Message- From: Dhirendra Kulkarni [mailto:[EMAIL PROTECTED]] Sent: 19 October 2001 06:48 To: [EMAIL PROTECTED] 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 This e-mail, and any attachment, is confidential. If you have received it in error, please delete it from your system, do not use or disclose the information in any way, and notify me immediately. The contents of this message may contain personal views which are not the views of the BBC, unless specifically stated.
Re: how to export data
I just posted in normal way of posting mail. I did not understand what u mean by html mail. - Original Message - From: Will Dyke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 19, 2001 3:53 PM Subject: RE: how to export data Dhirendra, Please don't post html mail to the list. The fact that sqlplus says that the statement is invalid means that this is an oracle question, rather than an ant question. I suggest that you ask the question in a more appropriate forum. Will -Original Message- From: Dhirendra Kulkarni [mailto:[EMAIL PROTECTED]] Sent: 19 October 2001 06:48 To: [EMAIL PROTECTED] 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 This e-mail, and any attachment, is confidential. If you have received it in error, please delete it from your system, do not use or disclose the information in any way, and notify me immediately. The contents of this message may contain personal views which are not the views of the BBC, unless specifically stated.
Re: how to export data
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: [EMAIL PROTECTED] Tel: +91 80 558 1487-90 ext. 2416 Dhirendra Kulkarni [EMAIL PROTECTED] 10/19/01 11:18 AM Please respond to ant-user To:[EMAIL PROTECTED] 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=""> 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 alsoiam getting invalid statement. So how do i export data. Please help Thanks DK
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
Re: how to export data
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