Xref: alice comp.databases.oracle.misc:30536 comp.databases.oracle.server:48301 Path: alice!news-feed.fnsi.net!news.idt.net!dispose.news.demon.net!demon!colt.net!Pollux.Teleglobe.net!news.emirates.net.ae!not-for-mail From: "Eega Ramesh Kumar, Vani" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server Subject: Re: Temporary tables Date: Wed, 5 May 1999 19:08:56 +0400 Organization: ETISALAT Message-ID: <7gpn05$aj31@news1.emirates.net.ae> References: <7fvqfp$lnn$1@nnrp1.dejanews.com> <6QOU2.194$FA1.16920@news.cwix.com> <7g4kg2$ss9$1@nnrp1.dejanews.com> <7g58g8$7qe$1@news.inet.tele.dk> X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Lines: 65 Hi, Oracle does not need any temporary table to create.When there are transactions to be done, Oracle creates temp segments and deletes after the transaction.You can make a table space temp and specify this table space as temp for that user so that all temp segments required will be created and deleted by oracle it self If you need any more info please mail me. Finn Ellebaek Nielsen wrote in message <7g58g8$7qe$1@news.inet.tele.dk>... > wrote in message >news:7g4kg2$ss9$1@nnrp1.dejanews.com... >> Correct me if i am wrong,but i thought that this statement creates a table >> called 'temp' but doesn't make it a temporary table.The burden of deleting >> this table lies on the user.What i need is a statement that creates a >table >> that lasts the length of the transaction and gets deleted by the system at >> the end of the transaction. >> >> >> In article <6QOU2.194$FA1.16920@news.cwix.com>, >> "Dave Fowler" wrote: >> > Try, >> > Create table temp as Select column_name from table_name; >> > >> > this will leave table temp in user schema. User Must have create table >> > privilege. >> > Check Oracle manual on select statement for more details. >> > >> > HTH, >> > Dave Fowler >> > Oracle Developer DBA >> > >> > wrote in message >> > news:7fvqfp$lnn$1@nnrp1.dejanews.com... >> > > Hi >> > > Can anyone please tell me how to create temporary table in Oracle. >> > > I know in sybase it can be done by saying >> > > select column_name from table_name into #temp_table_name. >> > > >> > > Thanks >> > > >> > > -----------== Posted via Deja News, The Discussion Network >> > ==---------- >> > > http://www.dejanews.com/ Search, Read, Discuss, or Start Your >> > Own >> > >> > >> >> -----------== Posted via Deja News, The Discussion Network ==---------- >> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own > >That's a new feature of Oracle8i, look up the documentation for CREATE TABLE >(ie CREATE GLOBAL TEMPORARY TABLE) if you've got that. > >HTH. > >Finn > >