Home » SQL & PL/SQL » SQL & PL/SQL » SELECT and tablespaces (10g, Red Hat)
SELECT and tablespaces [message #333934] Mon, 14 July 2008 22:47 Go to next message
griff
Messages: 2
Registered: July 2008
Junior Member
Hello,

Is there a way to execute a select query on multiple tablespaces?

Is there a way to execute a select query on a specified tablespace?

Thanks.
Re: SELECT and tablespaces [message #333936 is a reply to message #333934] Mon, 14 July 2008 22:52 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated above

>Is there a way to execute a select query on multiple tablespaces?
NO!

>Is there a way to execute a select query on a specified tablespace?
NO, SELECT operates against tables; not tablespaces.

Re: SELECT and tablespaces [message #333938 is a reply to message #333934] Mon, 14 July 2008 23:07 Go to previous messageGo to next message
griff
Messages: 2
Registered: July 2008
Junior Member
I should add more context. I am using the Oracle Database 10g Express Edition. In this edition, when a tablespace reaches 32 GB, it will not accept any more inserts.

I have a program that is filling up a table X in tablespace T. When X fills T up, I want to keep running my program, so I create a new a new tablespace T1 and create a new table X in T1.

I want to run a SELECT query on table X which exists on both tablespace T and T1.

How do I do that?
Re: SELECT and tablespaces [message #333940 is a reply to message #333938] Mon, 14 July 2008 23:19 Go to previous message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
griff wrote on Mon, 14 July 2008 21:07
I should add more context. I am using the Oracle Database 10g Express Edition. In this edition, when a tablespace reaches 32 GB, it will not accept any more inserts.

I have a program that is filling up a table X in tablespace T. When X fills T up, I want to keep running my program, so I create a new a new tablespace T1 and create a new table X in T1.

I want to run a SELECT query on table X which exists on both tablespace T and T1.

How do I do that?


You do that by continuing to violate your license with Oracle.

Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine.

as stated on
http://www.oracle.com/technology/products/database/xe/index.html
Previous Topic: ^ character
Next Topic: order of executing procedures
Goto Forum:
  


Current Time: Sat Dec 03 18:28:44 CST 2016

Total time taken to generate the page: 0.09034 seconds