about data dictionary

[Former Member]

Hi,

Plz tell what happen when data exceeds the limit given by size category .

Points sure.

thanks,

anshu.

[Former Member]

hI

There will not be any problem if the number of records in a standard table exceed the size allocated.

It is for the DBA's to set aside the file space for it.

You can change it but not advisable.

if the data increases SAP will increast the size of the table automatically

<b>Reward if usefull</b>

[Former Member]

HI

Database size increases dynamically

[Former Member]

Hi Anshu,

<b>Size Category</b>

The Size Category field enables you to specify the maximum number of records you expect this table to hold. You are setting the size of the initial extent and next extents, as well as the maximum number of extents allowed for this table. 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.

The size categories are always 0 through 4, but the number of expected records in each size category will change with every table based on the length of a row. Choose an appropriate category based on the maximum number of records you expect that table to hold.

When choosing a size category, be generous. In R/3 it is much better to over-estimate than underestimate this parameter.<b> If the size category is too small and the table grows larger than the initial allocation, the RDBMS allocates another extent. Secondary extents reduce performance and require a table-space reorganization to remove. Reorganizations can be very difficult to perform on a large database, especially one that requires high availability. It is much easier to reduce an overly generous size category than it is to increase an underestimated one.</b>

Regards,

Vijay