Quick question as google seems to be unhelpful this morning

From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Wed, 6 Jan 2010 09:27:03 -0600
Message-ID: <C5533BD628A9524496D63801704AE56D379CF1C355_at_SPOBMEXC14.adprod.directory>

So, can you turn off logging on an external table via 'alter table' or am I asking too much? :)

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>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 06 2010 - 09:27:03 CST