Powerdesigner tip set 3

1. When an oracle script is generated by PDM, an error occurs when the database object (table, field, and so on) exceeds 15 characters.

   The solution is to open the PDM, And the menu bar of the database will appear. Go to database & edit current DBMS & script & Objects & table & maxlen, and increase the value (Originally 30 to 15 characters ), for example, change to 60. If the length of a table or other objects is incorrect, you can select the corresponding objects (column, index, user, procedure, trigger, and synonmy!

   This operation modifies the file D:/program files/Sybase/powerdesigner 15/resource files/DBMS/ora10gr2. XDB (different database versions and different files ). You can save it for the next time.

2. Why is the warning "Existence of index" detected after a table is created?

   A table shoshould contain at least one column, one index, one key, and one reference.

   This warning error does not occur if you do not check the existence of index!

   This means that no index is created for the table, and at least one index is required for a table. This is a warning and it doesn't matter if you don't care!