Solution:
Extend the tablespace size
alter database datafile 'xyz.dbf' resize 1000M (The new total size)
Getting the datafile: Go to DBA->Segment management and Tablespaces in TOAD.
Sometimes the system may not have enough space for increasing tablespace file size.
Create a new file and attach it to the tablespace
ALTER TABLESPACE
ADD DATAFILE 'abc.dbf' SIZE 100M
AUTOEXTEND ON
NEXT 1024K
MAXSIZE 250M
No comments:
Post a Comment