Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

SQL Developer 3.1 Data Pump Wizards (expdp, impdp) - This article gives an overview of the Data Pump Wizards included in SQL Developer 3.1.



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
Tomasz

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
dbms_datapump_get_status(12...)
ORA-39002: invalid operation
ORA-39174: Encryption password must be supplied.

tried this on sqldeveloper 3.1.07

Tim... said...

Hi.

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.

Cheers

Tim...

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...

Hi.

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?

http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php#DataPumpAPI

Cheers

Tim...

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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)