RE: (solved) RE: Quick question as google seems to be unhelpful this morning
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Jan 2010 09:57:19 -0600
Actually this didn't quite work as expected.
To alter the table and change the logfile you must specify ALL the access
parameters, otherwise you'll get errors selecting from the external table.
Just wanted to pass that along.
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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Taylor, Chris David
Sent: Wednesday, January 06, 2010 9:48 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: (solved) RE: Quick question as google seems to be unhelpful this
morning
Found it.
alter table <table_name>
access parameters
(nologfile);
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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Taylor, Chris David
Sent: Wednesday, January 06, 2010 9:41 AM
To: 'Stephane Faroult'
Cc: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Quick question as google seems to be unhelpful this morning
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
