Home » RDBMS Server » Backup & Recovery » pl/sql code
pl/sql code [message #212750] Mon, 08 January 2007 03:12 Go to next message
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
Littlefoot
Messages: 20897
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: recover data from 10g to 9i
Next Topic: how to recover database if o/s corrupted & also loss server?plz step by step with script with de
Goto Forum:
  


Current Time: Tue Dec 06 15:52:42 CST 2016

Total time taken to generate the page: 0.14693 seconds