topic Re: table size in Application Development and Automation Discussions

table size

Former Member — Fri, 19 Feb 2010 12:13:37 GMT

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.

Re: table size

Former Member — Fri, 19 Feb 2010 13:13:27 GMT

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.

Re: table size

Former Member — Fri, 19 Feb 2010 13:57:36 GMT

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

Re: table size

Former Member — Sat, 20 Feb 2010 05:09:46 GMT

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

Re: table size

StMou — Thu, 25 Feb 2010 13:33:13 GMT

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

Re: table size

Former Member — Thu, 25 Feb 2010 13:50:48 GMT

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