pl/sql code [message #212750] |
Mon, 08 January 2007 03:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
subhajit
Messages: 14 Registered: December 2006
|
Junior Member |
|
|
Hello all,
I am using vb6 and Oracle 9i. I want to take a .dmp file of a table. For that i want to write procedure and call it from vb6 code. Can u plzz help me out to write such a procedure.
|
|
|
Re: pl/sql code [message #212768 is a reply to message #212750] |
Mon, 08 January 2007 04:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
.dmp file is to be created using the Export utility at the operating system command prompt. The simplest way would be this:
EXP username/password@database TABLES=your_table FILE=my_export.dmp
I don't know Visual Basic, but I guess you do. So, what is the way to run an operating system command from Visual Basic? If you know how to do it, you'll know how to create an export file.
For more options about Export, read Oracle Utilities Guide.
[EDIT] Forgot to add the 'TABLES' parameter
[Updated on: Mon, 08 January 2007 04:23] Report message to a moderator
|
|
|