Posts

Showing posts with the label Extend tablespace in SAP system

Extend tablespace in SAP system

To resize a tablespace in a SAP-Oracle system there are two ways. if you want to resize an existing datafile , you can do it with sqlplus as explained in http://bbdd-error.blogspot.com.es/2017/09/extend-tablespace.html If you want to add another datafile to an existing tablespace you can´t do it with sqlplus because it will generate differences between database catalog and SAP catalog... so it is mandatory to do it with brtools First of all you need to know tablespace name you are going to resize and path in witch you are going to add the new datafile, also it is important follow existing naming policy.. Tablespace Name MBytes Used Free Used Largest --------------------------------- ---------------- ---------------- ---------------- ------ ---------------- SYSTEM 2,048 285 1,763 13.9 1,762 SYSAUX 2,0...