Attribute and Attribute Group Customization Examples

ALTER TABLE MCT_<repository ID> MODIFY (C<ATTRIBUTE-NAME> VARCHAR2(10));

UPDATE CATALOGATTRIBUTE set ATTRIBUTELENGTH=10 where CATALOGID=<repository ID> and NAME='<ATTRIBUTE-NAME>';

This example shows how to modify the length of PRODUCTID and SHORTDESC to 10 and 50 respectively.

ALTER TABLE MCT_3323 MODIFY (CPRODUCTID  VARCHAR2(10));
UPDATE CATALOGATTRIBUTE set ATTRIBUTELENGTH=10 where  CATALOGID=3323 and NAME='PRODUCTID';

Navigate to the repositories screen and view the repository.

Modify the attribute length and save the repository.

The new length of the attribute is shown on the user interface. You need not change anything on the user interface while modifying the repository.