topic Re: Help needed in table maintenance in Application Development and Automation Discussions

Help needed in table maintenance

Former Member — Wed, 09 Jul 2008 04:47:35 GMT

Dear all

I have to add a few fields in existing Z-table. When I try to add a field to the table, I get an error that

Table <table name> is too long (>1962). Can any one guide what's the meaning of this and how to correct the same.

Thanks in advance. Points for sure.

Regards

Dinesh

Former Member — Wed, 09 Jul 2008 04:51:15 GMT

Hi,

The total field lengths of the data elements used in your table is more than 1962, which is the max permissible limit.

Reduce the length of some of the text fields which you feel is extra and then embed your new field,

This should solve your problem.

Hope this helps!!!

regards,

Lalit Kabra

Former Member — Wed, 09 Jul 2008 04:52:58 GMT

Just write the new field name and before activating it do

go to Utilitis,Database Object, database Utility, Activate and adjust database.

Regards

Aditya

Former Member — Fri, 12 Jun 2009 10:17:22 GMT

resolved.