Re: sqlplus

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sun, 17 Nov 2002 00:53:16 GMT
Message-ID: <0MBB9.60049$QZ.9668@sccrnsc02>

Yes.
select table_name from dba_tables where tablespace='MYTABLESPACE' order by table_name;

syntax not checked.
Jim
"ad" <noSpam_at_hotmail.com> wrote in message news:KGBB9.6568$dz2.784924_at_stones...
> is it possible to list the tables in a tablespace using sqlplus?
>
>
Received on Sat Nov 16 2002 - 18:53:16 CST