OraFAQ Forum: SQL & PL/SQL » General question about temporary tables

Home » SQL & PL/SQL » SQL & PL/SQL » General question about temporary tables (Oracle 11GR2, WIN Server 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

General question about temporary tables [message #648504]

Wed, 24 February 2016 05:49

OlafCologne
Messages: 11
Registered: September 2008
Location: Cologne

Junior Member

Example:

select * bulk collect into my_temp_storage from student;

Question:

If the temporary table ever created on the hard disk and the data is written?

Or you can let everything run in memory?

Thank you!

Report message to a moderator

Re: General question about temporary tables [message #648506 is a reply to message #648504]

Wed, 24 February 2016 06:40

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

It's all run in memory

Report message to a moderator

Re: General question about temporary tables [message #648508 is a reply to message #648504]

Wed, 24 February 2016 06:43

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do it with a very big table and you will see the error "ORA-04030: out of process memory when trying to allocate %s bytes".

Report message to a moderator

Previous Topic:	Re: Return ColumnNames in lowercase. (split from highjacked thread http://www.orafaq.com/forum/t/175479/0/unread/#msg_648450 by bb)
Next Topic:	ORA-00600: internal error code

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 31 07:16:20 CDT 2026