Creating temporary tables is a bad idea anyway since they
generate many entries in the logs and all too often don't have
indexes resulting in full table scans when a join is made. Try to
use views instead.
Dan.
Sergey Beloborodov wrote in message <363a6fc3.0_at_news1.starnetinc.com>...
>No You can not (unfortunately). After ALTER TABLESPACE ... TEMPORARY You
>can place _temporary_ segments in this tablespace _only_.
>
>But of coarce there are a lot of tricks how to do it (depending of the
>requirements). One of them: make special naming conversion for these
tables
>(to use sid and serial# from v$session in the name of this table; this is
>necessary). After that You are free to create those tables. To clean them
>up necessary to write small cron-like procedure (using DBMS_JOBS for
>example) to query v$session and certan segments with very simple logic: if
>there is table for unexisting session then drop it. Modification of dbdown
>or dbstart script will be helpful as well (as always will be non-zero time
>between calls for clean-up process). This is ganna work. Unfortunately
>necessary to code it in PL/SQL ;-(
>
>Best regards,
>Sergey
>
>cljones wrote in message <36392DFC.100B_at_concentric.net>...
>>Hey - yes you can -
>>
>>create tablespace tmp temporary
>>:
>>.
>>
>>create table temp
>>:
>>.
>>tablespace tmp;
>>
>>
>>
>>Billy Verreynne wrote:
>>>
>>> news.ht.net.tw wrote in message <706l5n$8ft$1_at_ftp.ht.net.tw>...
>>> >In SQL Server, we can create a session temp table.
>>> >This temp table is indepandent with other session.
>>> >This table will auto destory when session closed.
>>> >Can I do it in Oracle?
>>> >How to do it.
>>>
>>> Simple answer. No. It's not a feature that's directly supported by
>Oracle.
>>>
>>> But then we can go into a whole debate as to the purpose of these temp
>>> tables in SQL-Server... :-)
>>>
>>> regards,
>>> Billy
>
>
Received on Sun Nov 01 1998 - 13:03:12 CST
