RE: Upgrade to 8.1.7.2 on Linux -- an interesting happening

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 21 Sep 2001 08:17:32 -0700
Message-ID: <F001.00394BDC.20010921082027@fatcity.com>

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: wweaver_at_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_at_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: Mark Leith
INET: mark_at_cool-tools.co.uk

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