Re: Temporary Workspace and Archive Logs

"Jim" <jimnmitsy_at_cableone.net> wrote in message news:tlteqs9bvskhe3_at_corp.supernews.com...
> Oracle 8.1.6 running on NT, using developer 6i, forms/reports
>
> 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
>
>
>

create a global temporary table.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Wed Jul 25 2001 - 22:14:23 CEST