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. Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office: 615-517-3355 Cell: 615-354-4799 Email: chris.taylor@xxxxxxxxxxxxxxx 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@xxxxxxxxxxxx] Sent: Wednesday, January 06, 2010 9:37 AM To: Taylor, Chris David Cc: 'oracle-l@xxxxxxxxxxxxx' 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@xxxxxxxxxxxxxxx <mailto:chris.taylor@xxxxxxxxxxxxxxx> > -- //www.freelists.org/webpage/oracle-l