Skip to Main Content

Java Development Tools

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!

Optimize foreign key constraint for cascade deletion.

PamelaFeb 10 2014 — edited Feb 10 2014

Hello,

Jdeveloper version: 11.1.2.3.0

I saw this blog and found something new for me: http://snag.gy/qI6dY.jpg

From the UI of jdeveloper there is an option to select every table to select its foreign key and to set it for cascade deletion.

My project is deployed on several databases. I am wondering where is this change listed. None of the project files is modified.

Should I make this change (from Restricted to Cascade) for every database that I am using?

Here is the blog where I saw this: http://tompeez.wordpress.com/2013/04/22/master-detail-insertdelete-sample/

I have my object associations optimized for cascade deletion but without the option above set I still get constraint violations...

Regards

This post has been answered by Timo Hahn on Feb 10 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2014
Added on Feb 10 2014
3 comments
347 views