Re: An Oracle newbie question

From: Winnie Liu <poohland_at_hotmail.com>
Date: Wed, 8 Jul 1998 22:14:44 -0700
Message-ID: <6o1jca$p2c@sjx-ixn2.ix.netcom.com>

If you are using SQL Loader to load the table. Try to add 'unrecoverable' in the ctl file and use the direct path to speed up the loading. If you are creating the large table out of something else, I remember you can always specific to use unrecoverable in creating a table. When you use unrecoverable, that table will bypass any redo log and oracle will actually building up the data block instead of inserting into the data block

Winnie Liu

Stuart Hunter wrote in message <35A349E4.508B9E01_at_informatica.com>...
>Hi
>I'm loading a large table for a datawarehouse, and I'm not interested
>in recovery if anything goes wrong. How do I switch off transactions so
>that the data is inserted unlogged. I'm not in a position to use any
>bulk loaders - I'm convinced there must be a way to switch off
>transaction logging for a particular table for a specified operation.
>
>Any information much appreciated
>
>Thanks
>
>Stuart Hunter
>Informatica Software Ltd
>UK
>e-mail : shunter_at_informatica.com
>
Received on Thu Jul 09 1998 - 00:14:44 CDT