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!

Space occupied by a column

Sainath0907Feb 19 2015 — edited Feb 20 2015

Hi,

I want to find out the total space occupied by a column of a table. The table I have is of size 2TB size having some 20 columns.

I wanted to find out how much space can be saved if I removed a column from the table.

I have tried multiplying the number of rows with avg_col_len, but I don't know if the result is right or wrong.

Please guide me through this issue.

Thanks

Sainath

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2015

Added on Feb 19 2015

#general-database-discussions

8 comments

3,498 views