From Bambang.Setiawan@Sidola.com Thu, 15 Mar 2001 19:41:12 -0800 From: "Bambang Setiawan" Date: Thu, 15 Mar 2001 19:41:12 -0800 Subject: Re: Script to know the size of each table in a schema ? Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi , Thanks a lot for your help , Ruth : ) sincerely yours, =bambang= <> Bambang Setiawan <> >>> "Ruth Gramolini" 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" 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@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@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@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@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@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@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).