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 personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.