How to add datafile using brtools?what are steps?
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.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?
How to uncar car/sar files in a single shot?
What is the difference between central instance & application server?
If a background job runs more than the time it should be completed normally then what actions will u take?
What is transport domain?
On a particular system how you can get a list of the users with development access on a particular system?
Why can't we do it thru some other client?
What is the difference between – support package, kernel and sap note?
how to do system refresh?not the client copy but the-standard-system-refresh.
Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance
User wants lock ASAP then what will u do?
What are the different options available for scheduling a background job? What start conditions type can be used?
Explain the system log?
How to lock or unlock a transaction code using sm01?
I am installing a sap j2ee engine at crm. When it reaches phase 22 it halts for more than 10 minutes and gives up starting the system. What should I do?