OraFAQ Forum: Server Utilities » Creating dmp file on a button's click

Home » RDBMS Server » Server Utilities » Creating dmp file on a button's click (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating dmp file on a button's click [message #344738]

Mon, 01 September 2008 02:36

virmahi
Messages: 266
Registered: April 2008
Location: India

Senior Member

Hi,
I have to create the dmp file on the click of a button on the form in a dot net application. I have exported the database through command prompt.
Can you please help me as what command to write on the click event of the button so that a dump file gets created in a specified directory.

I am new to this and not much done on this part. SO please help me on this.

Regards,
Mahi

Report message to a moderator

Re: Creating dmp file on a button's click [message #344749 is a reply to message #344738]

Mon, 01 September 2008 03:13

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

"How to execute an operating system command (which Export utility is) from a dot net application" is a dot net question, not Oracle one. Perhaps you should search for the answer to this question in the more appropriate (dot net) forum.

Report message to a moderator

Re: Creating dmp file on a button's click [message #344759 is a reply to message #344749]

Mon, 01 September 2008 03:50

virmahi
Messages: 266
Registered: April 2008
Location: India

Senior Member

Hi,
I have to use the exp command from oracle only but it would be embedded in Dot Net.
Please let me know the commandline syntax for exporting a dmp file when I have the parameters for username, password, servicename, databasename.
I have to execute the command from a client and the dump file needs to be created on the server.
Is it possible....please help me on this...after knowing the commandline I will try to embedd in dot net.

Thanks for your help,
Mahi

Report message to a moderator

Re: Creating dmp file on a button's click [message #344770 is a reply to message #344759]

Mon, 01 September 2008 04:05

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I have to execute the command from a client and the dump file needs to be created on the server.

This is not possible unless you can mount the server file system onto the client.

Regards
Michel

Report message to a moderator

Re: Creating dmp file on a button's click [message #344785 is a reply to message #344770]

Mon, 01 September 2008 04:33

virmahi
Messages: 266
Registered: April 2008
Location: India

Senior Member

I didn't get you. Can you please give me the syntax for exporting dump file on client itself......

Report message to a moderator

Re: Creating dmp file on a button's click [message #344820 is a reply to message #344785]

Mon, 01 September 2008 05:49

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

exp help=y

Regards
Michel

Report message to a moderator

Re: Creating dmp file on a button's click [message #344865 is a reply to message #344820]

Mon, 01 September 2008 08:05

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

For further reading, check Original Export and Import utilities as described in Oracle 10g Utilities book.

Report message to a moderator

Previous Topic:	Importing data from SPSS to oracle
Next Topic:	Getting export error ORA-39212

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 12 09:03:41 CDT 2024