Yes you can issue the alter table nologging but it will only be relevant for
certain operations not all UPDATE, DELETE, conventional path INSERT
statements.
Jim
Reference the following I found on metalink:
Doc ID: Note:1038660.6
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 21-NOV-1997
Last Revision Date: 02-MAY-2000
Language: USAENG
PURPOSE
This article gives further information about the options UNRECOVERABLE
in Oracle7 and NOLOGGING in Oracle8.
SCOPE & APPLICATION
For users requiring further information about these options.
The options UNRECOVERABLE in Oracle7 and NOLOGGING in Oracle8 can be used
when creating a table as select. They will send the actual create statement
to the redo logs (this information is needed in the data dictionary). All
rows loaded into the table during the create are not sent to the redo logs.
With UNRECOVERABLE in Oracle7 any subsequent Data Manipulation Language
(DML)
command on the table WILL be sent to the redo logs.
The UNRECOVERABLE option can be used in early versions of Oracle8 but will
eventually be replaced by the NOLOGGING option.
With NOLOGGING in Oracle8, although you can set the NOLOGGING attribute
for a table, partition, index, or tablespace, NOLOGGING mode does not apply
to every operation performed on the schema object for which you set the
NOLOGGING attribute.
Only the following operations can make use of the NOLOGGING option:
alter table...move partition
alter table...split partition
alter index...split partition
alter index...rebuild
alter index...rebuild partition
create table...as select
create index
direct load with SQL*Loader
direct load INSERT
All of these SQL statements can be parallelized. They can execute in LOGGING
or NOLOGGING mode for both serial and parallel execution.
Other SQL statements (such as UPDATE, DELETE, conventional path INSERT, and
various DDL statements not listed above) are unaffected by the NOLOGGING
attribute of the schema object.
-----Original Message-----
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; Jwalski3
<[EMAIL PROTECTED]>
Date: Wednesday, March 28, 2001 5:25 PM
>
>that has nothing to do with the question. But anyway, try ALTER TABLE
>NOLOGGING instead.
>
>oli
>
>
>[EMAIL PROTECTED] wrote
>> Alter database noarchivelog;
>>
>> will change the entire database.
>>
>> see the following for detailed information:
>>
>> http://technet.oracle.com/docs/products/oracle8i/doc_index.htm
>>
>> HTH, Jim
>>
>> -----Original Message-----
>> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>> Date: Wednesday, March 28, 2001 4:37 PM
>>
>> >I know it is possible when creating a table to specify no logging
>> >so that it doesn't generate redo logs. Is it possible, AFTER
>> >the table has already been created, to change it to nologging?
>> > Also this is a dev database that we don't care about doing any
>> >type of recovery and just want to do some quick loads -- is it
>> >possible to change the entire database to nologging?
>> >This is on Oracle 8.0.5.
>> >
>> >-----
>> >Sent using MailStart.com ( http://MailStart.Com/welcome.html )
>> >The FREE way to access your mailbox via any web browser, anywhere!
>> >
>> >--
>> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> >--
>> >Author:
>> > 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).
>
>--
>Oliver Artelt
>Oracle Certified DBA
>
>cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
>telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
>email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jim Walski
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).
