Title: RE: enable the partitioning option in database?.

i didn't find the directory ORACLE_HOME\rdbms\lib itself... there is one directory jlib, but in that there is no 'make' file....

my system is ora817 on win nt.

any help pls.

    -----Original Message-----
    From:   Molina, Gerardo [SMTP:[EMAIL PROTECTED]]
    Sent:   Wednesday, November 28, 2001 8:33 PM
    To:     Multiple recipients of list ORACLE-L
    Subject:        RE: enable the partitioning option in database?.

    Assuming you have installed the Oracle Partitioning option, there may be an
    extra step required to "enable" it, and that is to make sure you relink with
    the correct option.  See the following excerpt taken from MetaLink:

    To enable the Partitioning Option you must relink the rdbms executable.

    Ensure that the database is shut down and relink as follows:

    cd $ORACLE_HOME/rdbms/lib

    For 8.0.x:

    make -f ins_rdbms.mk part_off (to disable)

    make -f ins_rdbms.mk part_on (to enable)

    make -f ins_rdbms.mk ioracle

    For 8.1.x:

    make -f ins_rdbms.mk part_off ioracle (to disable)

    make -f ins_rdbms.mk part_on ioracle (to enable)

    HTH

    Gerardo

    -----Original Message-----
    Sent: Wednesday, November 28, 2001 5:55 AM
    To: Multiple recipients of list ORACLE-L



    hI GURUS'

    How can i enable the partitioning option in database?.

    Any idea?

    [EMAIL PROTECTED]> SELECT PARAMETER, VALUE FROM V$OPTION WHERE
    VALUE='FALSE';

    PARAMETER
    ----------------------------------------------------------------
    VALUE
    ----------------------------------------------------------------
    Partitioning
    FALSE

    Parallel Server
    FALSE

    Java
    FALSE

    Rgds,
    Nirmal.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Molina, Gerardo
      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).

Reply via email to