Re: Quick question as google seems to be unhelpful this morning

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Wed, 06 Jan 2010 16:37:20 +0100
Message-ID: <4B44AE30.8030501_at_roughsea.com>



Chris,

What about specifying the logfile as /dev/null ? (untried, but it would seem logical to me).

HTH S Faroult

Taylor, Chris David wrote:
>
> So, can you turn off logging on an external table via ‘alter table’ or
> am I asking too much? J
>
> I tried ‘alter table <table_name> nologfile’.
>
> I’ve got external tables where the logfiles are growing quite large.
> I’m trying to determine the best way to manage the logfiles and
> whether they’re even needed.
>
> Thanks,
>
> */Chris Taylor/*
>
> *Sr. Oracle DBA*
>
> Ingram Barge Company
>
> Nashville, TN 37205
>
> Office: 615-517-3355
>
> Cell: 615-354-4799
>
> Email: chris.taylor_at_ingrambarge.com <mailto:chris.taylor_at_ingrambarge.com>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 06 2010 - 09:37:20 CST

Original text of this message