Re: switch redo logs off for one table

From: Igor Izvekov <igoriz_at_cmtk.net>
Date: 18 Dec 2002 14:23:32 -0800
Message-ID: <9f17469e.0212181423.80e6eaf@posting.google.com>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<XL3M9.5895$jM5.16983_at_newsfeeds.bigpond.com>...
> The answer is no.
>
> Alternatives are 'create table BLAH nologging as select * from
> somewhere_else', or 'insert into BLAH select * from somewhere_else', because
> those two statements will respect the NOLOGGING attribute (in the second
> case, only if you've previously done an 'alter table BLAH nologging'.
>

"append" hint will also help here :
insert /*+ append */ into BLAH select * from somewhere_else

Igor Izvekov.

>
> "Andrei Romazanov" <romazanov.andrei_at_gfos.de> wrote in message
> news:atq23l$1fp2j$1_at_ID-70985.news.dfncis.de...
> > I meant naturally ARCHIVER-LOGs, not redo logs
> >
> > Sorry!
> >
> >
> >
Received on Wed Dec 18 2002 - 16:23:32 CST