Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: describe tablespace?
--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