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

Home -> Community -> Usenet -> c.d.o.server -> Find Empty Tables

Find Empty Tables

From: Charles Davis <cdavis10717_at_comcast.net>
Date: Thu, 29 May 2003 21:19:11 -0400
Message-ID: <3_Sdnd6lkMjJLEujXTWcqw@comcast.com> 





Hi, all!



I manage several SAP R/3 databases that each contain 25,000 tables and
exceed 1TB in size. They are of both 8i and 9i versions.



Does anyone have a process or query that scales up well and that can find
tables that are empty without doing a SELECT count(*) on each of the tables?



Thx.



charles
Received on Thu May 29 2003 - 20:19:11 CDT












Original text of this message













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