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 is the common storage file for oracle ?

0 Answers   IBM,

---

How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?

0 Answers   iGate,

---

once a request is imported,is there any way to undo it? how about version management?

1 Answers  

---

Hai which kernel version, and patch version and now in real time we need to apply? ie means which version is now running on real time?

4 Answers  

---

How to take back up on EP?

1 Answers  

---

tell me the situation where u involved in memory management?How can u troubleshoot the situation?

1 Answers   TCS,

---

what is the difference between re-do and mirror log? How it is related with database backup? Please explain the database backup concept in detail. Thanks in advance.:) regards preeti.

2 Answers   Accenture,

---

what are the logs that you can access at os level?and their paths?(like system log,batch job logs,spool logs,transport logs,support pack related logs,etc..)

3 Answers   Satyam, Sysnet,

---

How to configure TMS?

0 Answers  

---

How to uncar car/sar files in a single shot?

0 Answers   IBM,

---

Which transport directory is used to implement support package and add-ons?

0 Answers  

---

how to send an email from EP Portal.

2 Answers   IBM,

---