Skip to Main Content

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!

User defined properties not showing up in design center

610433Apr 16 2008 — edited Apr 16 2008
Hello,
I did a search on User Defined Properties in this forum but couldn't find my answer.
We are using OWB 10gR2.

I already added a user defined property called UD_ALTERNATE_SCHEMA to the TABLE class definition.
I signed on as repository owner, I switched to single user mode, used OMBREDEFINE on class definition "TABLE", I commited my changes switched back to multi-user mode and signed off.
Here's the proof (it's in bold):
OMB+> OMBDESCRIBE CLASS_DEFINITION 'TABLE' GET PROPERTY_DEFINITIONS
BUFFER_POOL BUSINESS_NAME CACHE_MODE CONSTRAINTS DATA_SEGMENT_COMPRESSION DEPLOYABLE DESCRIPTION FREELISTGROUPS FREELISTS GENERATION_COMMENTS INDEXES INITIAL INITRANS LOGGING_MODE MAXEXTENTS MAXTRANS MINEXTENTS MONITORING_MODE NEXT OVERFLOW PARALLEL_ACCESS_MODE PARALLEL_DEGREE PARTITIONS PARTITION_TABLESPACE_LIST PCTFREE PCTINCREASE PCTUSED ROWDEPENDENCIES_MODE ROW_MOVEMENT SHADOW_TABLESPACE SHADOW_TABLE_NAME TABLESPACE UD_ALTERNATE_SCHEMA UOID
OMB+>

Here is how I defined this new property for the TABLE class.
OMB+> OMBDESCRIBE CLASS_DEFINITION 'TABLE' PROPERTY_DEFINITION 'UD_ALTERNATE_SCHEMA' GET PROPERTIES (TYPE,DEFAULT_VALUE)
STRING NO

My question is this.
Shouldn't this new property be available for edit when I right-click on a table object in the GUI interface and then choose "Properties" and then choose "User Defined" tab? Unfortunately it is not showing up on any of my tables in any of my projects­.
Did I miss a step here? Or did I completely misundestand the concept of "User Defined Properties"?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2008
Added on Apr 16 2008
1 comment
576 views