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!

Partial table size of oracle table

geeta rawatSep 11 2018 — edited Sep 13 2018

Hi All,

I am on oracle apps R12. I want to know the total space consumed by few tables of oracle apps.

I know we can find out the total space from dba_segments table but I have a condition. I want to know the partial size of the table but i dont have any partitions on the table.

For eg. I want to know how much space SCOTT.EMP table is consuming for the records where date_of_joining > '01-jan-2018'.

Is it possible to put a condition while calculating the space ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2018

Added on Sep 11 2018

#general-database-discussions, #oracle, #r12

13 comments

637 views