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?

Report message to a moderator

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: 26766
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.

Report message to a moderator

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: 68686
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

Report message to a moderator

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?

Report message to a moderator

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: 68686
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

Report message to a moderator

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: 26766
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.

Report message to a moderator

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?

Report message to a moderator

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

Report message to a moderator

Previous Topic: Patch set information
Next Topic: Archive log summary
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:17:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.