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

From: <tday6_at_csc.com>
Date: Fri, 21 Sep 2001 09:23:07 -0700
Message-ID: <F001.00394D8D.20010921094025@fatcity.com>

I suspect that they do now. LOL

                    "Weaver,                                                           
    
                    Walt"                To:     Multiple recipients of list ORACLE-L  
    
                    <wweaver             <ORACLE-L_at_fatcity.com>                        
    
                    @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_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: 
  INET: tday6_at_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_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).

Received on Fri Sep 21 2001 - 11:23:07 CDT