Re: Temporary Workspace and Archive Logs

Sorry about that, We are running 8.1.6 database on NT, with Developer 6i

"BJ" <bernhard.jongejan_at_born2run.tmfweb.nl> wrote in message news:9jkt3e$kkj$1_at_cyan.nl.gxn.net...
> 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:42:48 CDT