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 will go about doing a client copy ?

0 Answers  

---

What are the Different types of authorisation tables?

1 Answers  

---

what are client settings?

1 Answers   GBT,

---

patchs can apply CI OR dialog server?

2 Answers   IBM,

---

there are 3 clients in quality(100,200,300) and two clients in production(100,300) ? how do you restore the 200 client after refresh ? what are pre steps need to be taken before system refresh in order to restore 200 client ?

2 Answers   L&T,

---

A role is assigned to 100 users and for one day only 10 users need to be able to access that role and the other 99 users should not have access. How do you do that?

3 Answers   IBM,

---

Table space creation

2 Answers  

---

What is purpose user group in SU01?

0 Answers   CLSS,

---

Where will u find transport error logs?

0 Answers  

---

What will you observe in System log (SM21)?

1 Answers  

---

I have deleted all the clients including default clients in SCC4. How to recover the default clients?

2 Answers   Infosys,

---

what is the size of ur oraarchieve directory? how can u prevent archiver stuck situation?

3 Answers   TCS,

---