Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SELECT STATEMENT
select tablespace_name from user_tables where table_name ='MYTABLE';
--
Asaf Shoval
Oracle Israel Support Center
John Duran <d3plan_at_hotmail.com> wrote in message
news:7tghqv$h5q$1_at_nnrp1.deja.com...
> How do you make a SQLPLUS SELECT statement and designate the TABLESPACE
> that the TABLE is on?
>
> John
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 07 1999 - 06:43:01 CDT