table size

[Former Member]

Hi Experts,

I have a z table on production table. It contains many record and is now full .How I can increase its size . Can we increase sizes of tables at production server.I dont want any manipulation in alrasdy saved records. How Can we increase size of standard table in prd server.

tHANKS.

[Former Member]

Hi ,

Table is not like a box that get's fill and you can't add more to it( this is what my understanding is).You'r table may be large but it can'rt be like you can not add more data to it untill there is no space in database.

[Former Member]

It's not the table that is full. Your system probably ran out of tablespace. In the system configuration you can define the amount of diskspace you wish to allocate for tables. I think it's done in transactions RZ10/RZ11. So best ask your SAP Basis guys to expand your allocated table space.

With kind regards,

Roel van den Berge

[Former Member]

Hi,

Table can never be getting full, when you are defining the size it means it allocate that much memory and if record exceeded the , it allocate the same space for the table and it goes on repeating till till space availabe in the disk.

Regards

Sagar

[StMou]

Hi,

See with your Administrator ( or DBA) . Normally all database have an auto extended capacity.

- 1er reason is the auto extend is disabled ( go to console and extend database)

- 2nd reason is the tablespace is full. Extend or create another.

- 3rd reason is physically the disk is full. Buy and add new Disk.

In all these three reason, you must see with your administrator.

Good luck

[Former Member]

Hi,

you can determe table size and growth for mysql and maxdb database.

http://help.sap.com/saphelp_nw04/helpdata/EN/9f/7086bc40920a41acc085527d80af68/content.htm

I hope it´s usefull.

Regards,

Daniel