Home » SQL & PL/SQL » SQL & PL/SQL » No logging?
No logging? [message #227368] Wed, 28 March 2007 02:00 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

hai,

I ask one doudt .
What is use of local nologging in index section in oracle .
CREATE INDEX IX_BRIAN_FACT_2_END_DATE_ID ON
F_BRIAN_FACT_2(END_DATE_ID)
LOCAL NOLOGGING;



Any body..

[Updated on: Wed, 28 March 2007 02:04]

Report message to a moderator

Re: No logging? [message #227380 is a reply to message #227368] Wed, 28 March 2007 02:12 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
What did the Oracle SQL Reference tell you?

SQL Reference
Specify whether the creation of the index will be logged (LOGGING) or not logged (NOLOGGING) in the redo log file. This setting also determines whether subsequent Direct Loader (SQL*Loader) and direct-path INSERT operations against the index are logged or not logged. LOGGING is the default.


LOCAL index

MHE
Previous Topic: How ordering works with NULL vaalue
Next Topic: how to use between
Goto Forum:
  


Current Time: Thu Dec 08 08:33:42 CST 2016

Total time taken to generate the page: 0.23076 seconds