2007 Aug 14 8:17 AM
Hi all,
I have given 0-20000 size category in technical settings of a perticuler database table.
Now i want to create 20001 record?
IS it possible.
is it allows or not.
vkr.
2007 Aug 14 8:20 AM
No it will not allow it will give shortdump
reward points to all helpful answers
kiran.M
2007 Aug 14 8:24 AM
No, it wont allow u. You have to change the size category.
2007 Aug 14 10:52 AM
HI
NO
it won't allow you to enter more values
if you want again you have to change the settings
reward if usefull
2007 Aug 14 10:55 AM
Hi VKR,
it's no problem, at least in our system.
I created a table with max 18.000 entries.
I inserted 40000 entries - no problem at all.
In transaction DB02 you can analyze your table.
Before the entries are made the table usually has 64 kb and one extent.
When the entries are made in my case it has 2048 KB and 17 extent.
I think it depends on how the table is created on the database - as long as the table is "auto extent" that's no problem.
Henner
2007 Aug 14 11:22 AM
Hi..
It will not create any problem. You can store more records.
Bcoz the Size category determines the Initial Storage Space for the Table.
But when you add more records it will create additional storage.
<b>Reward if Helpful</b>
Bluesky
