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

I've recreated a couple of these with the NOLOGFILE option, but I was hoping not to have to do this for all our external tables.

It appears to modify the logfile attribute of an external table you have to recreate the table but not 100% positive about this.

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  

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

-----Original Message-----
From: Stephane Faroult [mailto:sfaroult_at_roughsea.com] Sent: Wednesday, January 06, 2010 9:37 AM To: Taylor, Chris David
Cc: 'oracle-l_at_freelists.org'
Subject: Re: Quick question as google seems to be unhelpful this morning

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