Increase the Size of Tablespace March 31, 2007Posted by Muhammad Habib in DBA.
If you want to increase the size of tablespace, its so simple. You can do this by enterprise manager console. Increase the size of datafile for particular tablespace.
DATAFILE ‘/u03/oradata/ userdata02. dbf’
If you don’t have any free space on that partition of disk then you can add another datafile on the other partition for particular tablespace.
ALTER TABLESPACE app_data
ADD DATAFILE ‘/u01/oradata/ userdata03. dbf’
Now you can insert data with in this tablespace.