RE: Aarrrggghhh!!! Creating an index shouldn't be so hard!

At 03:06 PM 10/4/00 -0800, you wrote:

>>>>

<excerpt><smaller>Do you have the following init.ora parameters defined?  They are required for function-based
indices:</smaller><color><param>0000,0000,ffff</param> <smaller>query_rewrite_integrity = TRUSTED

query_rewrite_enabled = TRUE

<excerpt>You may also need a particular compatible setting, probably at least 8.1.6

</excerpt></smaller></color></excerpt><<<<<<<<

Well, I did have a bad compatible setting (8.1.0), but changing it to 8.1.5 didn't help. And I'm positive that function-based indexes were supported in 8.1.5

As to the two parameters, I can't find any indication that they tie into function-based indexes. Actually, after reading up on them, I'm no wiser.

---

Dennis Taylor

---

Don't worry about people stealing your ideas.  If your ideas

are any good, you'll have to ram them down people's throats.