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.

What do you know about Default user DDIC?

3 Answers  

---

can we give one check for all vendors in automatic payment run? how?

0 Answers   Powermec,

---

AS-IS & TO-BE process, who gets involved?

1 Answers  

---

How to resolve lock overflow issue . with out restarting the production system ?

2 Answers   L&T,

---

steps to congigure CMS in XI ?

0 Answers  

---

In which frequency your TR gets transported to other system?

1 Answers   Accenture, Wipro,

---

1.what is the difference between ecc5 and ecc6 ? 2.in workbech request can we import specific clinet only?if 3 or 4 clinets 4.what is the main role domain controler?

1 Answers   HCL, IBM,

---

What happens if you restart the system, will you loose the trace file, or can you see?

3 Answers  

---

What is the difference between installing SAP R/3 and installing a SAP CRM system? OR, what are the installation steps for i) Installing an SAP R/3 and ii) Installing SAP CRM /SAP PLM/SAP business suite?

4 Answers  

---

WHAT ARE THE STEP BY STEP PROCESS TO APPLY PATCHES ON SAP R/3 SYSTEM?

6 Answers   Accenture, Collabera,

---

If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?

2 Answers   TCS,

---

How to fiind if there are an expensive SQL statements running if yes, What to do?

1 Answers  

---