‎2007 Jul 26 3:09 PM
hi
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
‎2007 Jul 26 3:18 PM
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
‎2007 Jul 26 3:11 PM
‎2007 Jul 26 3:13 PM
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
‎2007 Jul 26 3:13 PM
The Size wat u mention is the expected....
when the entries exceeds, the size of the table wil automatically be increased...
cheers...
‎2007 Jul 26 3:18 PM
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
‎2007 Jul 26 3:25 PM
Hi,
The table's size will be increased automatically.
Regards.
Marcelo Ramos