Simple question on logging..
Hi Gurus, How can I turn off logging for a table in Oracle7.3 database. Iam planning to reorg thru ctas and want to use append hint for loading data. SQL alter table tt unrecoverable; alter table tt unrecoverable * ERROR at line 1: ORA-01735: invalid ALTER TABLE option SQL alter table tt nologging; alter table tt nologging * ERROR at line 1: ORA-01735: invalid ALTER TABLE option TIA peter. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Simple question on logging..
ALTER TABLE yourtable NOLOGGING - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 4:33 PM Hi Gurus, How can I turn off logging for a table in Oracle7.3 database. Iam planning to reorg thru ctas and want to use append hint for loading data. SQL alter table tt unrecoverable; alter table tt unrecoverable * ERROR at line 1: ORA-01735: invalid ALTER TABLE option SQL alter table tt nologging; alter table tt nologging * ERROR at line 1: ORA-01735: invalid ALTER TABLE option TIA peter. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Simple question on logging..
Title: RE: Simple question on logging.. -Original Message- From: Peter R [mailto:[EMAIL PROTECTED]] How can I turn off logging for a table in Oracle7.3 database. Recoverable/unrecoverable is not a persistent attribute in 7.3.4 The unrecoverable option only applies to the create table but not to any subsequent operations. But starting with Oracle 8.0, the nologging option (which replaces the deprecated unrecoverable) on a create table will also apply to subsequent operations like Direct SQL*Loader and direct-load inserts. If you don't specify logging/nologging at table creation time then, as expected, the setting will be taken from the tablespace defaults.