Home » SQL & PL/SQL » SQL & PL/SQL » Work Tables/Temp Tables
Work Tables/Temp Tables [message #19417] Fri, 15 March 2002 02:43 Go to next message
uma
Messages: 67
Registered: May 2001
Member
I am joing mutiple tables which are big to populate a target table. I am getting an error for TEMP tablespace is out of extents when the query running. So I want to split my query in to multiple queries. I have 4 tables TABL1,TABL2,TABL3,TABL4. I want to join TABL1,TABL2 to create a WKTABL1 then I want to join WKTABL1 to TABL2 to get WKTABL2 then join WKTABL2, TABL4 to populate the target table. But I don't want WKTABL1, WKTABL2to be permanent. How to solve this problem? I am not very excited to get extents for my TEMP table space. Perhaps I prefer to go for WKTAB approach. Performance vise it is good too.

Thanks

Uma

Report message to a moderator

Re: Work Tables/Temp Tables [message #19419 is a reply to message #19417] Fri, 15 March 2002 04:29 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
try creating temporary table. but temporary tables are simmilar to permanent table except the fact that their contains are temporary for each session

Report message to a moderator

Previous Topic: REPORT IN CHARACTER MODE (URGENT)
Next Topic: tables in non-default tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 07:04:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.