The imp utility is for importing, not export. To perform an export, and to be able to take a logical backup of your database, you will have to use the exp utility instead.
The exp utility is just like any other command line utility. I am not a VB programmer, but I do know that VB lets you make calls to OS command line utilities. Using the VB routines to call external programs, you can run a command similar to the following:
exp userid=system/manager@orcl file=exp.dmp full=yThis will perform an export of your entire (full) database. You will need the appropriate password for the SYSTEM account. The "@orcl" is a TNS entry to your remote database so you will have to configure your TNSNAMES.ORA config file to point to this database.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.