8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for SQL Developer 3.1 Data Pump Wizards (expdp, impdp)

Lesio said...

Nice and simple :).

What about Data Modeler and data change management (svn, branches, merging changes).

It can be very usefull for DBAs. Please write some articles about it.

Best Regards

Jet said...

The Import Wizard of sqldeveloper cannot deal with dump with encryption password:
There is no field from the import wizard where you put the encryption password.

Exception: ORA-39002: invalid operation
ORA-39002: invalid operation
ORA-39174: Encryption password must be supplied.

tried this on sqldeveloper 3.1.07

Tim... said...


I would suggest you mention this on the OTN forum, or tweet to @thatjeffsmith and it will probably get added. They are very responsive to suggestions.



PT said...

This post is simple and valuable!

My head was spinning to think of doing this manually at the cost of the reliability of the operation.

Thank you so much for posting this information.

RobD said...

Is it possible to perform this action from command line?

Tim... said...


I'm not really sure. I would like to think the CLI would include all functionality at some point.

Of course, if you are considering using the command line, why not just use the datapump api from SQL Plus?




Alex Buzunov said...

Came by this great post.
Great job!
At some point I tried to automate DataPump jobs too.

Wrote DataWorm using Python/wxPython: https://github.com/alexbuz/DataWorm/blob/master/README.md

It's drag-n-drop tool generating expdp/impdp commands and executing them in Putty.

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.