I have an Oracle dump file (.dmp) that is currently on my local drive. How do I import this file to an Oracle database?...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Use the imp utility to load the file. Here is the syntax:
imp system/manager file=yourfile.dmp full=y
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.