Re: Temporary Workspace and Archive Logs

"Jim" <jimnmitsy_at_cableone.net> wrote in message news:tlrqmv60fdub4f_at_corp.supernews.com...
> We do a lot of number crunching and sorting... and only need a temporary
> tables to hold the numbers, for sorting and calculations) to print on the
> report. If the Database failed recovery of these tables is not necessary.
> I have created the tables like so
>
> CREATE TABLE PTS_INDEX unrecoverable CACHE TABLESPACE data STORAGE
 (INITIAL
> 3M) AS SELECT * FROM KCM.PTS_INDEX;
The usual story. NOLOGGING (which is what you *should* be using in 8.1.6, as opposed to the old 'unrecoverable' keyword) does NOT mean 'switch off all redo'. It means turn off the generation of redo for certain, rather specialised, forms of inserts (primarily, SQL Loader direct loads, direct load inserts, and inserts into index leaf nodes). Boring old conventional inserts ALWAYS generate redo, whatever the logging status of the table.

If you want a table to be truly no logging, then consider the 8i 'create global temporary table' syntax.

Regards
HJR
>
> kcm.pts_index is just a template, always empty..The calculations run, and
> insert into PTS_INDEX like normal
>
> INSERT INTO pts_index
> VALUES(sig,TO_CHAR(xdt,'DD-MON-RRRR'),xindex,sel,fund,xdaily,'',rate);
>
> nothing difficult, nothing fancy...
> My archive logs are 100MB, usually switching about 1 time every 2 days.
> When I run this report my archive logs switch about every 4 min while the
> report is running..
>
> How can I tell oracle this is a temporary table and don't worry about
> Archiving!!!!??
>
> Thanks in advance
>
> Jim McCraw
>
>
Received on Thu Aug 09 2001 - 06:48:07 CDT