on 09-10-2009 2:12 PM
Hi
I have a problem with one of the ztables i have created and transported from development to quality. The value in the parameter MAXIMUM_EXTENTS is 300 in quality server and UNLIMITED in the development server. I am getting a short dump when i try to load more than 10000 records in the QA server. can any one please help me with steps i need to do to change the paramer MAXIMUM_EXTENTS to unlimited in qaulity server.
Regards
Yatin Thakkar
permanent solution: convert your tablespace to locally managed tablespace with ASSM. read SAP note 646681.
until then, go into SE14 and check STORAGE PARAMETERS
click on F5 to go in CHANGE mode
change MAXIMUM EXTENTS to 505
change NEXT EXTENT to a much higher value such as 10240.
good luck.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Yatin,
here we go ...
shell> sqlplus / as sysdba
SQL> alter table <TABLE> storage (maxextents unlimited);
The value for MAXEXTENTS is stored in the SAP DDIC table TGORA. For more information - please check sapnote #666061
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.