Re: SELECT STATEMENT

If what you mean is specifying a tablespace when selecting from a table, then it is not an option...The table is in the tablespace that it was created in, so there is no need to specify it when selecting from it...

If, however, you mean that 2 tables exit with the same common name ( say table1) and you wish to select from one in a particular tablespace, well, no...the tables do not have the same name even tho it may appear to be the case...the actual table name for table1 is schemaname.table1 and the other table1 is schemaname2.table1

Oracle will not allow duplicate table names, so there will be no need to specify a tablespace in a select statement...  

John Duran <d3plan_at_hotmail.com> wrote:

>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.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Thu Oct 07 1999 - 09:19:03 CDT