actual size
Hi,Is it possible to use a single SQL query to return the actual (used) size of a single table and its related indexes including lob index and lob segments
without using DBMS_SPACE?
requirements
1. Returns
a. table used size
b. indexes used size
c. lob index used size
d. log segment used size
2. No user defined function used.
3. No DBMS_SAPCE because it won't provide combined used size in one statement
Just ask the possibility. if yes then how?
I know it sounds ridiculous though.
Thanks,
Sha
without using DBMS_SPACE?
requirements
1. Returns
a. table used size
b. indexes used size
c. lob index used size
d. log segment used size
2. No user defined function used.
3. No DBMS_SAPCE because it won't provide combined used size in one statement
Just ask the possibility. if yes then how?
I know it sounds ridiculous though.
Thanks,
Sha
0