Re: Shuting off redo's

From: zhuchao <chao_ping_at_163.com>
Date: 18 Jul 2002 21:47:16 -0700
Message-ID: <d8e45edf.0207182047.6f6c68a4_at_posting.google.com>


> Vissu
>
> I would use:
> alter table table_name nologging;
>
> That would turn off logging for one table, but not the whole system.
>
> You could turn it of before the export then:
> alter table table_name logging;
>
> When you're done to turn it back on.

hei, your way won't work in oracle.
Nologging option is only enable for a few operations like create index, ctas , sqlldr direct path load.etc. Import will still write to redo logs.
Add larger redo logs when doing import, to prevent ckpt not complete alert.
Also you can try to set sort_area_size larger when import create index and pkindex.
Try add index=n to speedup import. Received on Fri Jul 19 2002 - 06:47:16 CEST

Original text of this message