Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Select across Tablespaces
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
![]() |
![]() |