Bayt.com

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

Oracle OLAP Database Administration
user-image
Question added by Md A Wahid , Oracle Database Administrator , LankaBangla Finance Limited
Date Posted: 2013/09/20
Upvote (0) Views (11) Followers (0) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
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;

Write Your Answer
More Questions Like This