Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

 
 
 
 Category : Home > ERP / CRM > SAP     

Resize or add datafiles using brspace


This is a quick reference for SAP brspace utility.

To add a new file to tablespace (to keep the same size as the previous file and keep the same
location) run:

brspace -c force -f tsextend -t [tablespace name]

The file properties such as size, autoextend, filesystem will default to the file that was
added previously


To add a new file and specify a filesystem run:

brspace -c force -f tsextend -t [tablespace name] -f [filesystem name]


To resize database file using brspace utility

brspace -c force -f dfalter -a resize \
-f [path to file] -s [size in Mb]


To view system tablespace information i.e. free space, run:

brspace -f dbshow -c tsinfo -s SYSTEM


  Options
 
   del.icio.us  |  newsvine  |  digg  |  furl  |  google  |  yahoo  |  Ma.gnolia  |  vigillar  |  reddit  |  technorati  |  icerocket  |  pubsub

     (Average: 5 / Votes: 3)   Rate this tip:    

  Details
Tip reference : #153
views : 10802
Added on : 01/09/07
Submited by : h8dk97
 
Send a message Send a message Printer friendly output Printer friendly output
Display this member's tips Display this member's tips (219)
 
 
<< Previous
 Most viewed tips 
  Databases > Oracle > Security : How to unlock Oracle user account  
  Databases > Oracle > Performance Tuning : How to enable trace in Oracle  
  Databases > Oracle > DR : Adding new datafiles to standby database  
  Operating Systems > Unix : How to kill Unix user session  
   
  All categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Mobile Phones / Tablets | Office Software
 
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com