| pl/sql code [message #212750] |
Mon, 08 January 2007 03:12  |
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  |
 |
Littlefoot
Messages: 21823
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
