Pages

Wednesday, January 29, 2020

Extend tablespace or add datafile size in Oracle for SAP using sqlplus


Pre-requisite:
Make sure that there is enough free space available in File System


Procedure :

     1. Login into the system with oracle or ora<sid>
     2. Open the sqlplus prompt using below command
           sqlplus / as sysdba
     3. At the SQL prompt use the below command alter the Tablespace size
          alter tablespace <TABLESPACENAME> add datafile '/oracle/<SID>/sapdata<no>/<DATAFILE folder ex- sr3_223>/<DATAFILE name ex- sr3.data223> size 10000M autoextend off
       

    4. commit;


Suggestion :
Create <DATAFILE folder> under the required sapdata folder.




No comments:

Post a Comment