topic Re: table creation in Application Development and Automation Discussions

table creation

Former Member — Thu, 26 Jul 2007 14:09:16 GMT

in table creation i mentioned the size of table ranges 0 to 20,000 records, In the middle i want to increase the size. how to change the size

Re: table creation

Former Member — Thu, 26 Jul 2007 14:11:29 GMT

hi,

the size of DB table will be increased automatically.

Re: table creation

Former Member — Thu, 26 Jul 2007 14:13:00 GMT

Hi Jyothsna,

The value you specify is just an aproximated value, if you exceed this value nothing diferent is going to happen. But in order to maintain best performace you should try to specify a reasonable value for your table.

Regards,

Marcelo Moreira

Re: table creation

Former Member — Thu, 26 Jul 2007 14:13:48 GMT

The Size wat u mention is the expected....

when the entries exceeds, the size of the table wil automatically be increased...

cheers...

Re: table creation

Former Member — Thu, 26 Jul 2007 14:18:58 GMT

when u activate the table in data dictionary.. then it is created in database and allocated corresponding tablespace, which u give in technical settings.

Though there will be no problem if no of records increase...

yet u can always change technical settings at any time.

So increase the size of the table and activate it..

Reward if useful

regards

Prax

Re: table creation

marcelo_ramos1 — Thu, 26 Jul 2007 14:25:34 GMT

Hi,

The table's size will be increased automatically.

Regards.

Marcelo Ramos