[RESOLVED] [2.0] Generating a dump file from an Oracle DB with C#

[drattansingh]

Hi. My question concerns Oracle connected to C#. I'm well familiar with connecting oracle with c# so that's no problem.

I also know how to generate a dump file by typing a few commands in the cmd prompt and it works properly. However, I want to create a little application that will generate this dump file automatically to some directory which will be hardcoded for now.

Is there any way to do this? I'm thinking of a simple application that has a connection to the Oracle DB. This application has a button which when clicked will generate the dump file.

Regards,
Jennifer

[jmcilhinney]

Whatever you normally type at the command prompt you can send programmatically. You would use Process.Start to run a console window and then send the instructions to it via its standard input. Gigemboy has submitted code in the VB.NET CodeBank to redirect the standard streams. The principles will be exactly the same in C#.

[GaryMazzone]

Are you talking about using the exp command? IF so create a parameter file then use the process start as mentioned above.

[drattansingh]

Thanks. I got it to work - Jen