How to add datafile using brtools?what are steps?
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.
Is This Answer Correct ? | 0 Yes | 0 No |
What are the key activities that you perform as part of sap basis support?
After client copy is table space and database sizes will be increased or not?
I have deleted all the clients including default clients in SCC4. How to recover the default clients?
How to add authorizations, how you will maintain profiles?
When should we use Transactional RFC?
how many max application server we created in company. last limitation pls tell me in figure?
I want to find all non executed transaction list (user wise) for last three months one option is through st03n but in that i have to find by each and every t-code there is any facility to get this list user wise
To check if oracle processes are running?
For example, my sap system having patch number was 8.I want to apply patch 9 and 10.Mistakenly I will apply the patch directly 11 without applying 9 and 10.How sap system will recognize this problem?
Screenshot document for solution manager installation.
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
I'm getting the below error while trying to import request into Quality. Please help me. This is tp version 376.01.14 (release 701, unicode enabled) E-\\x559\sapmnt\trans\bin\TP_DOMAIN_KED.PFL could not be opened. EXIT Error in \\x559\sapmnt\trans\bin\TP_DOMAIN_KED.PFL: transdir not set. tp returncode summary: TOOLS: Highest return code of single steps was: 0 ERRORS: Highest tp internal error was: 0208