Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to reduce size of online and bigfile tablespace of production database at oracle 11g

user-image
Question added by Md A Wahid , Oracle Database Administrator , LankaBangla Finance Limited
Date Posted: 2013/09/20
Dahlia Hassan
by Dahlia Hassan , Oracle DBA , ITWorx

if the tablespace have free space and you need to reduce the size of it you can use the following command:

ALTER TABLESPACE TABLESPACE_NAME RESIZE  40G; (for example)

 

or you can shrink table space size as the following:

ALTER TABLESPACE TABLESPACE_NAME SHRINK SPACE;

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.