Um, Bambi, is this an exact cut and paste?... you are missing a ' after X
--- "Bellow, Bambi" <[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: 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). __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).