Answer Posted / 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 will determine whether your sap server is unicode or ascii ?

1144

---

What is private mode? When does user switch to user mode?

1187

---

I would like to know the version or name of SAP that is implemented in real time?

1158

---

what is the difference b/w 4.7EE & ECC5.0?

2414

---

steps to congigure CMS in XI ?

2324

---

What settings we have to do in EEWC while using slandalone SAP-CRM system.

2677

---

How to perform a sap-export and import tables in sap from os level?

1287

---

Explain reference and service user in sap. What are their uses?

1062

---

what is the difference b/w 4.6c & 4.7EE?

2274

---

How to deactivate IPC in standalone CRM.

3025

---

Using Tc SGEN I have generated 74% job and later I have terminated the job. I wish to start generating from where it stopped I have refreshed but to no chance, nothing was done. How should I further proceed so as to complete the remaining job?

1110

---

Which transaction do you use to check buffer statistics ?

1247

---

How can I restrict the user from printing?

1101

---

What are the different types of rfc and explain what transactional rfc is?

1121

---

What is the different type of users in sap?

1101

---