SELECT and tablespaces [message #333934] |
Mon, 14 July 2008 22:47  |
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 #333938 is a reply to message #333934] |
Mon, 14 July 2008 23:07   |
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  |
 |
BlackSwan
Messages: 26766 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
|
|
|