Yes, this is truly a moral dilemma.
I'm gonna buy a couple six packs of Moose Drool and ponder on it, or maybe
not ponder on it and concentrate on football instead, this weekend.
--Walt Weaver
Bozeman, Montana
-----Original Message-----
Sent: Friday, September 21, 2001 10:20 AM
To: Multiple recipients of list ORACLE-L
The question is - are you going to be the one to tell them? :>
Isn't Anita an Oracle employee?
Say no more.. :P
-----Original Message-----
Walt
Sent: Friday, September 21, 2001 16:55
To: Multiple recipients of list ORACLE-L
I decided to try it out.
I tried creating both a bitmap index and a function-based index as follows:
=====================================
TESTDB.US.ORACLE.COM.SYSTEM.SQL>create table test_table(
2 col1 number,
3 col2 varchar2(50));
Table created.
TESTDB.US.ORACLE.COM.SYSTEM.SQL>create bitmap index index1 on
test_table(col1);
Index created.
TESTDB.US.ORACLE.COM.SYSTEM.SQL>create index index2 on
test_table(UPPER(col2));
Index created.
=======================================
When I tried this on the original, non-patched 8.1.7.0.1 Standard Edition I
got the usual "Feature not enabled" message.
So, yeah, I'd say the functionality is there. Gosh, I wonder if Oracle is
aware of this?
--Walt Weaver
Bozeman, Montana
-----Original Message-----
Sent: Friday, September 21, 2001 8:15 AM
To: Multiple recipients of list ORACLE-L
Have you tested to see if the Enterprise Edition options now are
working? Function-based indexes, etc...
-----Original Message-----
Buchan
Sent: Friday, September 21, 2001 6:55 AM
To: Multiple recipients of list ORACLE-L
Yes - same thing - just applied the 8172 patch yesterday to two 817
Standard Edition servers on SuSE 7.2 and they both now indicate
Enterprise
Edition with all the options enabled.
- Bill.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
