How to Add an Oracle datafile using BRTOOLS 1. Logon Logon to to the the syste systems ms as ora< ora > 2. Exec Execut utee brto brtool olss 3. Sele Select ct “2 “2 – Space Space man manage ageme ment” nt” 4. Select Select “1 – Exte Extend nd tables tablespac pace” e” 5. Sele Select ct “3 “3 – tabl tables espac pacee name name ↵ 6. Sele Select ct “C – Con Conti tinu nuee 7. Select Select “3 – New file file to to be added added (file (file path) path) (Optio (Optional) nal) 8. Select Select “5 “5 – Size Size of the the new file file in MB MB (Optio (Optional nal)) 9. Select Select “6 “6 – Auto exte extend nd (Yes/ (Yes/No) No) (Opt (Option ional) al) 10. Select “7 – Maximal file file size in MB (Maxsize) (Maxsize) (Optional) 11. You can see the sql statement statement in option “9 – SQL command. (Optional) 12. To continue select select “C – Execute the sql command. command. 13. Select continue and confirm confirm the return return to BRTOOLS menu. 14. Exit from the the “Space management” menu using b (back) 15. Now it is possible possible to exit from BRTOOLS using option “9 – Exit program”. program”. NOTE: Check next page for a detailed procedure
How to extend an Oracle datafile using BRTOOLS Summary
1. Logon to the systems as ora 2. Execute brtools 3. Select “2 – Space management” 4. Select “4 – Alter data file” 5. Select “3 – Alter data file action (action)” and type resize ↵ 6. Select “4 – Tablespace name (tablespace)” and type the tablespace name 7. Select “5 – Data file names (file)” and specify the complete path of the data file 8. Check the input data and select continue to launch the BRSPACE interface. 9. Confirm the call to “BRSPACE” 10. Select “7 ? New data file size in MB (incrsize)” and specify the new size in MB 11. Check the input data and select continue (this will actually execute the resizing). Look for any error messages. 12. Select continue and confirm the return to BRTOOLS menu. 13. Exit from the “Space management” menu using b (back) 14. Now it is possible to exit from BRTOOLS using option “9 – Exit program”. NOTE: Check next page for a detailed procedure
Detailed procedure
1. Logon to the systems as ora 2. Execute brtools
3. Select “2 – Space management”
4. Select “4 – Alter data file” It is obligatory to fill items marked with “~”.
5. Select “3 – Alter data file action (action)” and type resize ↵
6. Select “4 – Tablespace name (tablespace)” and type the tablespace name
7. Select “5 – Data file names (file)” and specify the complete path of the data file
8. Check the input data and select c to continue to launch the BRSPACE interface. Datafiles can be checked within the SAP system with transaction DB02 -> Current sizes -> Select the tablespace -> Data files / Temp files
9. Confirm the call to “BRSPACE”
10. Select “7 ? New data file size in MB (incrsize)” and specify the new size in MB
11. Check the input data and select continue (this will actually execute the resizing). Look for any error messages.
12. Select continue and confirm the return to BRTOOLS. 13. Exit from the “Space management” menu using b (back) 14. Now it is possible to exit from BRTOOLS using option “9 – Exit program”.