Home » SQL & PL/SQL » SQL & PL/SQL » Temporary Table Problem
Temporary Table Problem [message #19374] Wed, 13 March 2002 09:45 Go to next message
uma
Messages: 67
Registered: May 2001
Member
I have created one temporary table Yesterday by using this query.

CREATE GLOBAL TEMPORARY TABLE INSPCOPY ON COMMIT PRESERVE ROWS AS SELECT * FROM
INSPECTION_TYPE

But this table is stay even today. Is this table not session specific? Means when you signed off it won't go away.

Thanks,

Uma

Report message to a moderator

Re: Temporary Table Problem [message #19376 is a reply to message #19374] Wed, 13 March 2002 11:12 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
Hi,

A temporary table is as persistant as a normal table. Only it's content is temporary for one specific session.

HTH
Maurice

Report message to a moderator

Re: Temporary Table Problem [message #19379 is a reply to message #19374] Wed, 13 March 2002 11:30 Go to previous message
uma
Messages: 67
Registered: May 2001
Member
Thanks. Looks like a view .

In that case, how to create some work tables? I don't want to keep these tables be cataloged but I want to create in the process but I don't want to keep them forever.

For example If I want to populate one target table and I have mulitiple tables table1, table2, table3 as my sources then I want to combine table1, table2 data to a work table 1 then I want to combine worktable1 to table3 to populate my target table. Is there any way to do this?

Thanks,

Uma

Report message to a moderator

Previous Topic: Insert and Where clause
Next Topic: ORA-4091 Mutating Tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 09:42:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.