Finding top 20 large objects/tables in database

  • From: "Anant (DBA)" <shastry17@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 7 Oct 2007 22:09:32 +0530

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

Other related posts: