I want to import a .dmp
file exported from another database, and I was wondering if anyone have experience on using GUI import option for .dmp
file from SQL Developer? I have searched a lot of documents, but I couldn't find any detail. I can use SYS or SYSTEM user to import.
Right-click on either the "Data Pump" or "Import Jobs" tree node and select the "Data Pump Import Wizard..." menu option. Enter the type of import you want to do and the name of the dump file that is the source of the data, then click the "Next" button.
Using the main menu, select Tools->Database Export. An Export wizard will open. At the top of the screen, enter a directory and file name.
what was this another database? was it oracle database? if yes the dmp file can be file exported by
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With