How to change default Max Length of Column name?

[lydiattc]

Hi,

I need to change the default Max Length of column name from 30 to 50. I tried to change it in sys.col$ table, but I got an error message saying "object necessary for warmstarting database cannot be altered."

Does anybody know how to change it?

Thanks,
Lydia

 

[carp]

You don't - 30 characters is the name limit for Oracle.

 

[Turkbear]

Hi,
In addition to the fact that you cannot alter that value, messing around with the dictionary tables/views directly is almost guaranteed to leave you with an unusable database.

 

[lydiattc]

Thanks.