Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> no logging clause

no logging clause

From: Peter Teoh <htmldeveloper_at_gmail.com>
Date: Thu, 29 Nov 2007 20:11:46 -0800 (PST)
Message-ID: <22f240d1-4d07-45b5-a1dd-1da2f69a5fcb@a35g2000prf.googlegroups.com> 





According to:



http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/clauses005.htm



tables can be created with nologging clause, so that its DDL/DML
activities are not logged into the redo log.   So my question is:
how do I enumerate a list of all existing objects that have nolog
status tagged to them?



Thank you in advance.
Received on Thu Nov 29 2007 - 22:11:46 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US