How to Increase the tablespace size
Hello All.
when i view the tablespace using TOAD. it shown the users tablespace has
0 free mgs
0 free pct
100 used pct
32767.98 Max Mb
and the script for the tablespace is
"
CREATE TABLESPACE USERS DATAFILE
'/home/oracle/oradata/simsdb/users01.dbf' SIZE 125M AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO;
"
what i have to do. does it increase automatically or i have to add more datafile to the tablespace.