Re: Temporary tables

It's not a really temporary table but it is a hint. In 7.3.x you can create tables in unrecoverable mode. This creation (as a select) will not write logging information. I have read, that in 8.x you can use nologging option which will shut off logging by inserts, too.
Hope this will help.
Andreas Prusch

In article <35B6100C.B44171D_at_merconet.com.br>,   Luis Cabral <cabral_at_merconet.com.br> wrote:
> Hi all,
>
> I have to do very complex report that can not be made
> with Reports. In fact, I will use Forms to process the
> data and store it in a temporary table, sort it , re-process
> and re-sort it, accumulate cascaded totals and then
> call Reports only to print it. After all I will drop all
> data from the temporary table. This report is to be run
> many times a day, each time generating 500-5000 temporary rows,
> that will be inserted and deleted almost imediatelly.
>
> Of course, I will put the temporary table in a separate tablespace,
> and size it accordingly.
>
> This should be nice, but the database has Archiving Logs,
> and there is a preocupation about the growing size of them,
> especially because they will hold, in this case of the temporary
> table, lots of data that no meaning at all - because of its
> temporary aspect.
>
> Anyone has worked with temporary tables and can give me
> some advice? Or should I use a other tool (like Powerbuilder or C++)
> that can hold and manipulate efficiently those 5000 lines in memory,
> thus not overcharging the database? (of course, I prefer to do
> it all with Oracle Tools)
>
> Thank you
>
> Luis Cabral
> cabral_at_merconet.com.br
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 23 1998 - 01:04:31 CDT