Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: describe tablespace?

Re: describe tablespace?

From: roobaron <member_at_dbforums.com>
Date: Fri, 06 Sep 2002 06:52:59 +0000
Message-ID: <1782088.1031295179@dbforums.com>

--desc_ts.sql

define ts="upper('&&1')"

select table_name,tablespace_name
from user_tables
where tablespace_name like &ts
/

to run
@desc_ts.sql %%

Have Fun

--

Posted via http://dbforums.com Received on Fri Sep 06 2002 - 01:52:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US