Answer / pm

If any object(table/index,Datafile will not reach maximum extents as u said) reaches maximum extents you can increase them using T-code SE14.

Go to SE14 >give the table name>click on edit>click on storage parameters>and you can increase the max.extents here.

If your table space is full you have to add Datafile or resize existing Datafile.

To add datafile please do as specified below.

1.If yours is unix login as ora<SID> and type brtools at command prompt.

2.in the menu select 2,space management

3.in the next menu select 1.extend table space

3.In the next menu select 3,tablespace name and it prompts for the name and type PSAPUNDO.

4.CONTINUE

5.CONTINUE

6.you will get the following screen.

Options for extension of tablespace PSAPUNDO (1. file)



1 * Last added file name (lastfile) ....... [/oracle/CRD/sapdata2/undo_1/undo.d

ata1]

2 * Last added file size in MB (lastsize) . [6800]

3 - New file to be added (file) ........... [/oracle/CRD/sapdata2/undo_2/undo.d

ata2]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [6800]

6 - File autoextend mode (autoextend) ..... [no]

7 # Maximum file size in MB (maxsize) ..... [10000]

8 # File increment size in MB (incrsize) .. [20]

9 - SQL command (command) ................. [alter tablespace PSAPUNDO add data

file '/oracle/CRD/sapdata2/undo_2/undo.data2' size 6800M autoextend off]



Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-



7.choose 5 if you want to specify size of Datafile.Also check whether enough space is available at OS level to add this datafile.(use df -k "path of directoy" to check space

8.click on continueand it will take few minutes to add the datafile and your tablespace is now extended!

You can execute this when SAP is Up and running,no need to stop SAP or DB.

How you can assign an object to 100 roles at time?

0 Answers  

---

What to do if If Buffer Hit ratio is less than 95%

3 Answers  

---

after changing some parameters in rz10 and restart,the system doesn't start up?what to do?

2 Answers   iGate,

---

What are the different types of rfc?

0 Answers  

---

Is there a difference between user ddic and sap_all/sap_new?

0 Answers  

---

what is the use of psaptemp table space?if we delete all the data files in temporary table space will oracle throws any error?

2 Answers  

---

WHEN I M TRYING FOR CREATING ROLE OF ECC6.0 IDES SO IT SHWOING DUMP ERROR: THERE IS NO MORE SPACE MEMORY BUT I HAVE INSTALLED ON 500GB HDD. PLS GIVE ME SOLUTION PLS IT'S VERY IMPORTANT & URGENT FOR ME.

5 Answers  

---

hi i want to know that how a transport request will be transported after being released . how it had to be carried to production system ?

5 Answers   Accenture,

---

Explain what is sap ides?

0 Answers  

---

Is it possible to install ecc 5.0 as a test system and not production, without installing solution manager?

0 Answers  

---

The Users are not able to save the data, as a BASIS ADMIN me to not able to save, what is the problem would be..?

4 Answers   Hexaware,

---

What is the deference between JSPM and SDM??

2 Answers   ABC,

---