RE: Quick question as google seems to be unhelpful this morning
Date: Wed, 6 Jan 2010 09:40:45 -0600
Well, the table is already created.
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.
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
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.
From: Stephane Faroult [mailto:sfaroult_at_roughsea.com] Sent: Wednesday, January 06, 2010 9:37 AM To: Taylor, Chris David
Subject: Re: Quick question as google seems to be unhelpful this morning
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.
> */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>