Friday, November 06, 2009

Export database

To do OIM development on local VM, frequent DB backup is necessary. We need some simple way to export and import db.
To export Oracle DB use command:
exp system/password@sid file=dumpfile log=logfilename full=y

To import Oracle DB use command
imp system/password@sid file=dumpfile full=yes