Re: Temporary Workspace and Archive Logs

Jim,

Is this syntax for oracle 7? Otherwise the syntax would be :

create global temporary table etc..

unrecoverable only skips the table creation during recovery

oracle 8.1 has the nologging option but this cannot be combined with the unrecoverable parameter. I tried:

ERROR at line 1:
ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE The cache option is normally used for small lookup tables to put data blocks at the most recently used side of the lru list in the buffer cache for full table scans.

I can't find the nologging parameter for oracle 7 table creation. Creating a separate tablespace in nologging mode is possible in v7. , which could serve your temp tables.

Bernhard Jongejan

Jim <jimnmitsy_at_cableone.net> schreef in berichtnieuws 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;
>
> 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 Tue Jul 24 2001 - 17:31:51 CDT