Skip to Main Content
Forums

SQL Developer Data Modeler

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.

unable to obtain alter script from data modeler

be here nowAug 24 2014 — edited Aug 26 2014

Hi,

I am trying to compare my model (reverse-engineered from a ddl script and slightly modified afterwards) with an existing schema in Oracle DB and obtain an ALTER script. I press "synchronize data dictionary with model", then I choose my connection and observe object tree. Apparently there is a difference:

Capture.PNG

After this I press "DDL preview" and expect to see an "alter table FACT_FREIGHT_CARS" script there, but for some reason the window is empty and no script is generated:

Capture2.PNG

Is there a specific reason for this?

I am using SDDM 4.0.2.840.

Thanks,

Kirill

Comments

Avi Miller-Oracle
Srividhya.PM wrote:
We have a OEL 5.5 server with OCFS2 installed used for Oracle Ebusiness suite.
You'll probably need to upgrade to Oracle Linux 5 Update 7 and the UEK to get OCFS2 with ACL support.
Dude!
The problem with "operation not supported" was already noted in 2009 and supposed to be fixed in a maintenance release.

http://oss.oracle.com/osswiki/OCFS2/NewFeaturesList
If EA's are turned on, the file system will now automatically support POSIX ACLS and selinux.

Do you have ocfs2-tools package installed?

What happens if you enable extended attributes:

mount -o remount,rw,user_xattr,noatime /APPL_TOP

You can see "man mount.ocfs2" for explanation of mount options.

Edited by: Dude on Sep 13, 2011 12:47 AM
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 23 2014
Added on Aug 24 2014
4 comments
1,812 views