Cant you get that information using DBMS_SPACE, DBA_SEGMENTS?
Thanks
--
LSC
On 10/7/07, Anant (DBA) <shastry17_at_gmail.com> wrote:
>
> Hi all,
>
> How to find the top 20 large objects/tables in production database. I
> found some script in google for that, but its going to create a stage table
> to do the sortings and atlast drops a table after giving the result. As our
> DB is in SOX..we will have problem. Can anyone please help me if you have
> any queries?.
>
> Thanks,
> Ann
>
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Oct 07 2007 - 12:27:50 CDT
