How to Increase the size of a tablespace
Answer: There are 2 ways to increase the size of tablespace.1. Add an Extra Data file to the tablespace
alter tablespace users add datafile '/u01/oradata/orcl/users02.dbf' size 25m;
2. Resize the Datafile that is currently supporting the tablespace. Some versions of Oracle does not like this, and brings the instance down, so do not use this unless you are really sure.
alter database datafile '/u01/oradata/orcl/users01.dbf' resize 50M;
No comments:
Post a Comment