Select across Tablespaces

From: <dschorsc_at_rtscinc.com>
Date: 2000/07/28
Message-ID: <8lsdv0$o7p$1@nnrp1.deja.com>#1/1

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