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 are the Parameters need to be set when connecting EP to r/3 system what are they?

0 Answers  

---

Explain table space?

2 Answers  

---

What is the system's configuration required to implement SAP.

0 Answers   IBM,

---

1. In which table support pack store....? 2. wht r things happing in back ground during DB backup..?

2 Answers   TCS,

---

Explain Client Export in SAP?

3 Answers   Cap Gemini,

---

sm21 shows the system log for the application server you're currently logged on.I want to see the system logs of all appliction servers.what to do?

2 Answers   iGate,

---

How to increase swap memory without doing any changes to Parameter value

2 Answers   IBM,

---

How to delete a table from Database level.

1 Answers  

---

Is there a way to perform sapgui 640 roll out using a centralized server?

0 Answers  

---

What is buffer synchronization?

6 Answers  

---

As a basis consultant what are the roles and responsibility's looking in to EP(EP monitoring, and trouble shooting and how to connect please let me some thing anybody plz help me)

3 Answers   IBM,

---

Hi there, i am a M.com, guy i want to learn sap application. is it possible? what r the courses i can persue? is it application or development ? also let me know institution names in chennai

1 Answers   CTS,

---