Home » RDBMS Server » Server Administration » temporary tablepsace
temporary tablepsace [message #281602] Sun, 18 November 2007 11:42 Go to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Can we export from temporary tablespace?
Ofcourse we can't create any object in temporary tablespace but can we export whatever data oracle maintains in temporary tablespace before the commit?
Re: temporary tablepsace [message #281604 is a reply to message #281602] Sun, 18 November 2007 11:50 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
Please explain in detail EXACTLY how your session will be able "see" uncommitted data?
Oracle's data integrity mechanisms preclude session B from accessing uncommitted data owned by a different session.
Your question is TOTALLY non-sensical.
Re: temporary tablepsace [message #281605 is a reply to message #281602] Sun, 18 November 2007 11:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, what is in the temporary tablespace is private to your session/transaction/query so it can't be used elsewhere.

If you explain what is your need maybe we can give some useful help.

Regards
Michel
Re: temporary tablepsace [message #281606 is a reply to message #281602] Sun, 18 November 2007 12:14 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Anacedent and Michel...
YOu both are absolutely correct..

Temporary tablespace only purpose is to provide segments for sorting.
BUt how exactly it works?
Re: temporary tablepsace [message #281607 is a reply to message #281606] Sun, 18 November 2007 12:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
They are not used only for sort operations.

Database Concepts
Part II Oracle Database Architecture
Chapter 2 Data Blocks, Extents, and Segments
Section Overview of Segments
Subsection Introduction to Temporary Segments

Please ALWAYS have a look at Concepts manual BEFORE posting a question 99% of answers are there.

Regards
Michel
Re: temporary tablepsace [message #281608 is a reply to message #281602] Sun, 18 November 2007 12:58 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
varu123,

Do you EVER try to answer your own questions before posting them here?
A true professional solves their own problem or at least spends a couple of HOURS looking for answers before bothering others.
Re: temporary tablepsace [message #281637 is a reply to message #281602] Sun, 18 November 2007 22:12 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Varu123, What you actually want? Do you clear with yourself?
Re: temporary tablepsace [message #281767 is a reply to message #281602] Mon, 19 November 2007 05:00 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
I thought the topic ended with MIchel's excellent article of Temporary segments..
I am new to oracle so my posts might sound that of a new bie. Smile
Previous Topic: Patch set information
Next Topic: Archive log summary
Goto Forum:
  


Current Time: Mon Dec 05 08:42:48 CST 2016

Total time taken to generate the page: 0.06417 seconds