Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Temporary tables
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_at_news.inet.tele.dk>...
><pcmerc_at_my-dejanews.com> wrote in message
>news:7g4kg2$ss9$1_at_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_at_news.cwix.com>,
>> "Dave Fowler" <d.fowler_at_cwix.com> 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
>> >
>> > <pcmerc_at_my-dejanews.com> wrote in message
>> > news:7fvqfp$lnn$1_at_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
>
>
Received on Wed May 05 1999 - 10:08:56 CDT