| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Exclude Tables from Archive log
efflerch_at_my-deja.com wrote:
>
> Hallo,
> is there a way to exclude tables from ARCHIVELOG.
> Of course this Tables have no triggers or constraits to other tables .
>
> Background is: I load nightly data from a ASCII-file via SQL*Loader,
> which are a datapool for the "real" Application. (I did SQL Command
> "Alter table xxx nologging")
> But unfortunately I have after the sqlload a script running which is
> doing lots of formating stuff.
>
> Today I have approx 80% Archiv-Log files due to of UPDATE commands on
> the datapool Tables executed by formating scripts.
>
> I'm using Oracle 8.1.5 on WinNT
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Check out the NOLOGGING setting for a table, combined with direct load and unrecoverable settings for SQL Loader.
HTH
--
We are born naked, wet and hungry...then things get worse Received on Fri Mar 03 2000 - 08:12:01 CST
 |
 |