Skip to Main Content
Forums

Database Software

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.

is it possible to export and import only constraints for a specific schema ?

JhilApr 9 2019 — edited Apr 15 2019

Dear Experts,

is it possible to export and import only constraints for a specific schema ?

There are n number of objects in a schema.

impdp process is very slow and running 16+ hours ..continuously.

We are planning to export only constraints and import them.

How do i EXCLUDE remaining objects like INDEXES, FUNCTIONS, TRIGGERS, etc .. (EXCEPT CONSTRAINTS) 

I want to exclude all objects including table rows, only i want to export CONSTRAINTS.

Can anyone tell me the best approach to achieve this ?

DB Version is 12.2

FYI : I have noticed, library cache lock occurred after impdp process initiated.

Thanks in advance

Comments

Philipp Salvisberg

I use GraalVM's JDK 11 on my MBP with macOS 12.0.1. The JDK is available only for Intel. However, it works well with rosetta2. This way I can use all features of SQLDev. And the JS based features are significantly faster.
For that I set the following in my /Users/phs/.sqldeveloper/21.2.1/product.conf :

SetJavaHome /Users/phs/Applications/graalvm-ce-java11-21.2.0/Contents/Home

You find the current JDK here: https://github.com/graalvm/graalvm-ce-builds/releases?q=21.2.0&expanded=true

1 person found this helpful
Niall

Very interesting. Thanks @philipp-salvisberg1 .
As you suggest, I've just tried GraalVM's JDK 11 and it seems to work well for me - even the JavaFX parts. The Welcome Page now works too :)
I'll update my blog post to include this alternative.
Note: I had to remove the quarantine attribute with the following command:
sudo xattr -r -d com.apple.quarantine /Library/Java/JavaVirtualMachines/graalvm-ce-java11-21.2.0

1 person found this helpful
1 - 2

Post Details

Added on Apr 9 2019
#database-key-features, #export-import-sql-loader-external-tables
6 comments
10,405 views