Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dbms_space package

dbms_space package

From: Suhen Pather <PatherS5_at_telkom.co.za>
Date: Fri, 20 Oct 2000 10:20:32 +0200
Message-Id: <10655.119828@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US