Re: Script to know the size of each table in a schema ?

From: Andy Duncan <andy_j_duncan_at_yahoo.com>
Date: Thu, 15 Mar 2001 04:31:53 -0800
Message-ID: <F001.002CD5D6.20010315022610@fatcity.com>

Hi Bambang,

> is there anyone who has the script ?
> furthermore , I need some information about relationship diagram which
> describe
> the relation among tables/view to calculate storage of objects ( i.e
> tablespace , datafile , segment , extent ) .

If you have Perl DBI available, Richard Sutherland is doing some amazing Perl work with a new module called DDL-Oracle. Included with the download are several tools (eg: ddl.pl, defrag.pl), which you might be able to adapt to fit your required usage? Anyhow, here's the download address:

=> http://www.perl.com/CPAN-local/modules/by-authors/id/R/RV/RVSUTHERL/

Rgds,
AndyD

---

andy_j_duncan_at_yahoo.com

O'Reilly's "Oracle and Open Source":
=> http://www.oreilly.com/catalog/oracleopen/

Orac, Perl/Tk and Perl DBI Database DBA & Development Tool: => http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/

---

Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andy Duncan
  INET: andy_j_duncan_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Mar 15 2001 - 06:31:53 CST