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!

Shrink bigfile tablespace

Salai.jayaveluApr 24 2017 — edited Apr 24 2017

Hi People,

I have a database version 11.2.0.3 in RHEL 5 X64. It has got the bigfile tablespace with total bigfile size of 1.46 TB out of which 681 GB is free and 814GB is used.

I would like to release this free space, can you please advice the approach to release the free space without any downtime.

Cheers

Salai

Locked Post

New comments cannot be posted to this locked post.

Locked on May 22 2017

Added on Apr 24 2017

#general-database-discussions

2 comments

2,097 views