From tday6@csc.com Fri, 21 Sep 2001 09:23:07 -0700 From: tday6@csc.com Date: Fri, 21 Sep 2001 09:23:07 -0700 Subject: RE: Upgrade to 8.1.7.2 on Linux -- an interesting happening Message-ID: MIME-Version: 1.0 Content-Type: text/plain I suspect that they do now. LOL "Weaver, Walt" To: Multiple recipients of list ORACLE-L @rightnow.com cc: > Subject: RE: Upgrade to 8.1.7.2 on Linux -- Sent by: root an interesting happening 09/21/2001 11:55 AM Please respond to 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: wweaver@rightnow.com 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: ListGuru@fatcity.com (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: INET: tday6@csc.com 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: ListGuru@fatcity.com (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).