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

Home -> Community -> Mailing Lists -> Oracle-L -> Finding top 20 large objects/tables in database

Finding top 20 large objects/tables in database

From: Anant (DBA) <shastry17_at_gmail.com>
Date: Sun, 7 Oct 2007 22:09:32 +0530
Message-ID: <5b294dab0710070939t56c9c799i8a3f3dcb42babcd0@mail.gmail.com>


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 - 11:39:32 CDT

Original text of this message

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