I **KNEW** it was something stupid. Thanks for the quick response, Tim! Bambi.
-----Original Message----- Sent: Wednesday, October 01, 2003 3:10 PM To: Multiple recipients of list ORACLE-L How about a break first? Namely, set a break using "break on report"... on 10/1/03 12:49 PM, Bellow, Bambi at [EMAIL PROTECTED] wrote: > Friends -- > > Did I miss something dying? The doc sez it's still there, but SQL*Plus > doesn't seem to be recognizing it... > > col owner form a10 > col segment_type form a5 > col segment_name form a45 > col a hea MEGS form 99999.999 > comp sum of a on report > set pages 1000 feedb off > > select owner,segment_type,segment_name,bytes/(1024*1024) a > from dba_segments > where owner in ('X,'Y') > and segment_type in ('TABLE','INDEX') > and bytes/(1024*1024) < 2 > / > > > Any clues, or am I just doing something stupid? > Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).