Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Resizing bigfile tablespace.

736579Jan 5 2010 — edited Jan 5 2010

Guys,

I have a big size table space in our production database and I would like to add some space ( 5GB ) to it as it is currently 100% full. While I am investigating a data pruge process in the database I would like to go ahead and resize the tablepsace so that activity can go on.

Is it ok to go ahead with the below command. Current size is 350GB

ALTER TABLESPACE TB_PSS_DATA RESIZE 355GB;

Thanks for all your help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2010

Added on Jan 5 2010

#general-database-discussions

5 comments

15,477 views