Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Qeustion regarding temp tablespace group

NayasSep 7 2012 — edited Sep 7 2012

Hi All,

I am new to this concept. I've been reading about it but there is something I am not sure to understand.
If I have a temp tablespace group using tablespace temp1 and temp2 and a user submit a large query, will the query use both temp1 and temp2 or just 1 of them?

Group Name: temp
Tablespace: temp01 (1 datafile temp01.dbf)
Tablespace: temp02 (1 datafile temp02.dbf)

Thank you!

This post has been answered by Aman.... on Sep 7 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2012

Added on Sep 7 2012

#general-database-discussions

3 comments

236 views