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