topic Re: SE11 in Application Development and Automation Discussions

SE11

Former Member — Tue, 14 Aug 2007 07:17:53 GMT

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.

Former Member — Tue, 14 Aug 2007 07:20:44 GMT

No it will not allow it will give shortdump

reward points to all helpful answers

kiran.M

Former Member — Tue, 14 Aug 2007 07:24:47 GMT

No, it wont allow u. You have to change the size category.

Former Member — Tue, 14 Aug 2007 09:52:54 GMT

it won't allow you to enter more values

if you want again you have to change the settings

reward if usefull

Former Member — Tue, 14 Aug 2007 09:55:28 GMT

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

varma_narayana — Tue, 14 Aug 2007 10:22:11 GMT

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>