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

Joe,

I have an idea.
What if we create a script that opens (with the user's default editor, of course)
every .sql file in the folder:

NT: %ORACLE_HOME%\rdbms\admin
*nix if you can get through the *nix install - you know how to rtfm

technically, it would be a virus - it could be the "man" v!rus, inflicting script headers on all unsuspecting users. a mut_at_tion could open up every file named "README.txt" on the filesystem.

I'm thinking of subcontracting it to the phillipines for a pair of jeans and a region-coding-angnostic DVD player.

Paul

"Joseph S. Testa" wrote:
>
> and yes i have a pl/sql script to run the dbms_space package is anyone
> is interested.
>
> Joe
> Bambang Setiawan wrote:
> >
> > Ya , you're right : )
> >
> > but I think I have to appreciate all the answers for my question ...
> >
> > one replied that DBA_SEGMENTS can be used to calculate
> > the size of each table in a schema ( in MBytes ).
> > It's big clue , I still found difficulty in its implementation...
> >
> > Do you have the script Tapas ?
> > please let me know : )
> >
> > HTH,
> >
> > =bambang=
> >
> > <> Bambang Setiawan <>
> >
> > >>> tapas dutta <tapasoracle_at_umtl.co.in> 03/16/01 02:25 >>>
> > HEY,
> >
> > THERE IS SOMETHING WRONG IN THE UNDERSTANDING.
> > BY THE MENTIONED SCRIPT ONE CAN ONLY KNOW THE NO. OF ROWS
> > PRESENT IN EACH TABLE FOR THAT PARTICULAR SCHEMA NOT THE SIZE.
> >
> > IS N'T IT.
> >
> > -----Original Message-----
> > From: Bambang Setiawan [SMTP:Bambang.Setiawan_at_Sidola.com]
> > Sent: Friday, March 16, 2001 8:45 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Script to know the size of each table in a schema ?
> >
> > Hi ,
> >
> > Thanks a lot for your help , Ruth : )
> >
> > sincerely yours,
> >
> > =bambang=
> >
> > <> Bambang Setiawan <>
> >
> > >>> "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> 03/15/01 11:40 >>>
> > You can spool the output of this SQL and run it.
> >
> > select 'select '''||table_name||''', count(*) from '||table_name||';' from
> > dba_tables where owner='SCHEMA_OWNER';
> >
> > To get the table name in the output you have to put 3 ' s before and after
> > the first ||table_name||.
> >
> > HTH,
> > Ruth
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, March 14, 2001 9:25 PM
> >
> > Dear Listers,
> >
> > I just made script to know the size of datafile in a tablepace ,
> > but I still have no idea to make a script to know the size of each table in
> > a schema ?
> >
> > 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 ) .
> >
> > thanks in advance : )
> >
> > =bambang=
> >
> > <> Bambang Setiawan <>
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Bambang Setiawan
> > INET: Bambang.Setiawan_at_Sidola.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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ruth Gramolini
> > INET: rgramolini_at_tax.state.vt.us
> >
> > 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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Bambang Setiawan
> > INET: Bambang.Setiawan_at_Sidola.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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: tapas dutta
> > INET: tapasoracle_at_umtl.co.in
> >
> > 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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Bambang Setiawan
> > INET: Bambang.Setiawan_at_Sidola.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).
>
> --
> Joe Testa http://www.oracle-dba.com
> Performing Remote DBA Services, need some backup DBA support?
> For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> ask :)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: paled_at_home.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).