Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

New Options for Data Pump Import Wizard

966438Sep 9 2024

I would like to suggest a few new options for the DBA -> Data Pump -> Import Jobs -> Data Pump Import Wizard. I'm using SQL Developer 23.1.1.

Currently, the options are: Data and DDL, Data Only and DDL Only.

It would be very helpful to have a checkbox option for:

  1. Disable Constraints before loading data (when either Data and DDL or Data Only is selected)
  2. Enable Constraints after loading data (when either Data and DDL or Data Only is selected)

Also, because of the rollback space limitations on the free-tier and dev-tier oci cloud, it would be nice to have another checkbox for:

  1. Commit every X number of rows, option.

These new options would make it a lot easier to move data between databases in different oci tenants.

Thanks,

Steve
Comments
Post Details
Added on Sep 9 2024
1 comment
43 views