Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> dbms_space package
Hi
I am using the dbms_space package to get the space used for
Partitioned
Tables.
dbms_space.unused_space('SYS','TABLE',
'TABLE
PARTITION','OUT1','OUT2','OUT3','OUT4','OUT5','OUT6','OUT7','P4')
We are using the Rule Based optimizer so I cannot generate any stats
using analyze.
Is there a way to use the dbms_space.unused_space proc without
substituting each of the partitions.
So what I need is to substitute just the Table Name and get the size
of
the table for all partitions.
I have checked on Metalink but I cannot get this info.
Received on Fri Oct 20 2000 - 03:20:32 CDT