Home » RDBMS Server » Backup & Recovery » pl/sql code
pl/sql code [message #212750] Mon, 08 January 2007 03:12 Go to next message
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
Messages: 21148
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

Previous Topic: Export DB from a linux system to a windows system
Next Topic: Is it possible to only exp/imp daily changes of the db?
Goto Forum:

Current Time: Sat Aug 19 15:27:11 CDT 2017

Total time taken to generate the page: 0.04822 seconds