Interested to Buy Any Domain ? << Click Here >> for more details...
How to add datafile using brtools?what are steps?
- 1 Answers
- 3455 Views
- AIHS, I also Faced
- E-Mail Answers
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
How will go about doing a client copy ?
I am attempting to complete a system copy of bw. When I try to go in to rsa1 afterwards I get the error message, "entry in inbound table already exists." What should I do to solve the problem?
If any errors coming during transport where it will be recorded and how will you rectify?transport log and active log
Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance
Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?
What is the difference between Party & Service without party in XI (ID)?
What is redolog file? Path?
What is business kpis ?
How to define logon groups?
How to find users used transaction codes which are not authorized for?
Where XML file is generated in solution manager?
Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com
You want to find out which users have an access to a particulat transaction. How would you do that?
Hi ,All What is the multi-threading and max connections for rfc. Actually i am facing problem while send large amount of idocs to external system using middle ware tibco r3 adapter. And how to enable these in SAP ?
How can you find the list of objects that have been repaired in the system?
