Vick

Right but do not expect that once a Tablespace is declare as in
"no Logging" you will "Redo Free" for all the DMl's done to the
objects inside this Tablespace .

http://www.adp-gmbh.ch/ora/misc/nologging.html

Oracle is tolerant but not that much :)

Yoav

-----Original Message-----
From: Quaglia Joseph P
[mailto:oracledba-ezmlmshield-x52907708.[Email address protected]
Sent: Thursday, May 31, 2007 3:44 PM
To: LazyDBA Discussion
Subject: RE: NOLOGGING at Table level

Hi,

The NOLOGGING option can be checked at the tablespace level. Query
dba_tablespaces.


ALTER TABLESPACE <tablespace_name> NOLOGGING
ALTER TABLESPACE <tablespace_name> FORCE LOGGING -- to turn back on


Hope this helps.

Joe Q

-----Original Message-----
From: msawant
[mailto:oracledba-ezmlmshield-x98752365.[Email address protected]
Sent: Thursday, May 31, 2007 9:24 AM
To: LazyDBA Discussion
Subject: NOLOGGING at Table level

Hi,

Oracle 10.1 on Windows
The DB is in NOARCHIVELOG mode.
* How would I check whether the tables that are in the DB, were created
using NOLOGGING or not?
* I need to be sure that even the Partitioned Tables have NOLOGGING set
on them.
* If there are any regular Tables/Partitioned Tables created that do
not have NOLOGGING set, how would I set the NOLOGGING option to them.


Thanks,
vick



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page