Home » SQL & PL/SQL » SQL & PL/SQL » Function Base Index with “INITIALLY DEFERRED” option (Oracle10g, Win2003)
Function Base Index with “INITIALLY DEFERRED” option [message #333402] Fri, 11 July 2008 10:09 Go to next message
weekend79
Messages: 188
Registered: April 2005
Location: Islamabad
Senior Member

Hi

Can i use “INITIALLY DEFERRED” option with Function Base Index?

If yes then please tell me the syntex as i fail embed “INITIALLY DEFERRED” option with my following Function Base Index.

CREATE UNIQUE INDEX C_Name ON Table_Name (case when Col1= 'T' then Col2 else null end);


Wishes
Re: Function Base Index with “INITIALLY DEFERRED” option [message #333403 is a reply to message #333402] Fri, 11 July 2008 10:12 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Enjoy!

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5010.htm#sthref6515
Re: Function Base Index with “INITIALLY DEFERRED” option [message #333405 is a reply to message #333403] Fri, 11 July 2008 10:21 Go to previous messageGo to next message
weekend79
Messages: 188
Registered: April 2005
Location: Islamabad
Senior Member

What to enjoy ? Sad
Re: Function Base Index with “INITIALLY DEFERRED” option [message #333413 is a reply to message #333405] Fri, 11 July 2008 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Statement syntax.

Regards
Michel
Re: Function Base Index with “INITIALLY DEFERRED” option [message #333688 is a reply to message #333402] Mon, 14 July 2008 03:08 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
To the best of my knowledge, the Deferred Syntax can only be used with Constraints, not with Indexes
Previous Topic: Getting Mutating error in Trigger
Next Topic: Table deletion
Goto Forum:
  


Current Time: Sat Dec 10 20:47:26 CST 2016

Total time taken to generate the page: 0.10172 seconds