Toad World® Forums

Checking for identifiers that are too long


#1

Is there a way to have TDM check for and flag identifiers that are too long for a given database platform (eg. Oracle). I am finding out some of my identifiers are too long only after generating DDL and running it against the target database.

Examples would be 30 characters for table names in Oracle, which generates “ORA-00972: identifier is too long”.


#2

Hello,

Examples would be 30 characters for table names in Oracle…

Please find attached a user package that does what you want.

Unzip the attachment and copy the .txg file to the location where you store your user packages. Default location is:
C:\Documents and Settings\user\My Documents\Toad Data Modeler\Installation anem\Packages{DCB5CB9B-CF65-4350-86B5-285D246FC5AC}

Open TDM.

Run Model Verification then.

The package works for Oracle models only.

If you have any questions, please write us back. Thanks.

Regards,

Vladka + TDM Team
VerificationsOR_user.zip (1.88 KB)


#3

Just a quick note: The package is available also in Library at: http://modeling.inside.quest.com/entry.jspa?externalID=3251&categoryID=34 Regards, Vladka