How to expand tablespace in Oracle 11G

Need to expand the tablespace or delete contents from CCTBLS(screenshot attached). Help wil be greatly appreciated.
Capture.PNG
maximus1974Asked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
Do you?  See if it is  set to auto extend:
select AUTOEXTENSIBLE, FILE_NAME from dba_data_files where tablespace_name='CCTBLS';

If that is YES, there is nothing to worry about as long as you have disk space.

If NO, then you can add another datafile to the tablespace or extend an exiting file.

ALTER DATABASE DATAFILE '/some/path/db_file.bdf' RESIZE 10G;

Where the file name is one of the files returned above and a size is whatever size you want it to be.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.