Re: Temporary tables

Rumor has it Oracle8i will have temporary tables. Until then the best thing to do is create the "temporary" tables in a separate tablespace and grant the appropriate permissions, etc. (Do not drop the tables and recreate them because you will either have to do regrants and incur the overhead of creating/dropping tables every time as well as creating tables in every schema or granting some high level system privileges.) As long as the batch procedure is not run by more than one process simultaneously you can just TRUNCATE the tables before and after the batch operation.

agrouza_at_hotmail.com wrote:

> Hi all,
>
> I recently had to create a batch procedure where I needed a temporary table.
> Apparently there is no such thing in Oracle ( like in Sybase SQL Anywhere
> where there is corresponding SQL extension ), so I need an advice of what is
> the best way to handle this. Should I create this table and clean it up
> regularly or maybe there is a cheaper alternative...
>
> Any ideas would be greatly appreciated.
> Thank you
> Anton
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Sep 30 1998 - 08:41:29 CDT