Re: Select across Tablespaces

Simple select statement would do good. Oracle make the implicit select and everything is transparent for DML.

In article <8lsdv0$o7p$1_at_nnrp1.deja.com>,   dschorsc_at_rtscinc.com wrote:
>
>
> I have a table that is in several tablespaces
 and I would like to
> perform a 'SELECT' across them. Can I do this
 easily or do I have to
> write a stored procedure that creates a
 database link REMOTE_CONNECT
> for each tablespace, select the data, put in a
 temp table. Repeat for
> each tablespace, adding to the result from each
 select to the temp
> table and then return that result set??
>
> This is very confusing so any help would be
 greatly appreciated!!
>
> Thanks in Advance.
>
> Dave
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jul 28 2000 - 00:00:00 CDT