Table size category

[Former Member]

Hi

I have one on tables. I created one table, in Technical settings i specified size category high limit. But my data is exceeded that limit.

so what to do?

If i enter it is store the data or it give any erorr?

[Former Member]

Hi Lakshmi,

The size category determines the probable space requirement for a table in the database.

You can select the categories 0 to 4 for your table. Each category is assigned a specific fixed storage area value in the database. When you create a table, initial space is saved for it in the database. If more space is required later as a result of data that has been entered, the storage space is increased in accordance with the category selected.

Press F4 on the field Size category to see the number of data records that can be maintained for the individual categories of your table without complications ensuing. These complications could be for example a reorganization becoming necessary because the maximum space to be reserved for the table was exceeded due to the maintained size category.

if u have taken "0" it accepts 0 to 4,500

if u have taken "1" it accepts 4,500 to 18,000*

up to 8 it is availbale

Therefore if u get the problem of size exceeds go for the next

number of size category u definetely get the soln.

Plz rewards points,

Thanks & Regards,

Ganesh.

[Former Member]

hi,

It stores the data.It wont show any error.

By default by defining the size we are dyanmically reserving the space to store the data for limited records.then automatically it store the data.

Regads,

Madhavi

[prasanth_kasturi]

hi

The size category determines the size of the initial extent and next extents, as well as the number of possible next extents. Choosing too low a number will cause one or more additional extents to be allocated.

An extent is the amount of space allocated for a table. The initial extent is the amount of space allocated for a table when it is created. If a table uses up that space, another extent will be allocated, causing the table's space to be extended.

A table that spans multiple extents decreases system performance, increases database maintenance, and lowers system availability, again because the database is usually taken offline for reorganizations

hope u understand

reward if helpful

regards

prasanth

[Former Member]

Hi lakshmi,

size category is used to define initial size of the table,by this that much size of space on the database server is reserved for the table.like

for 0 you are able to insert 0 to 7,100 records

for 1 you are able to insert 0 to 28,000 records

you have size categories from 0 to 8.

but you can insert more than 7100 records in a table whose size category is 0.when you insert 7101 th record it will allocate again 0 to 7100 records space.but to follow good standards and to reduce load on database server its better to define the size when you design a table.

rewards points if helpful.

[Former Member]

Hi,

Size category defines the expected number of records that the table is expected to hold. It will not give any error even the records are more.

Reward.