Re: Select across Tablespaces

How is it possible for you to have a table in multiple tablespaces?

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.
Received on Fri Jul 28 2000 - 00:00:00 CDT