RE: enable the partitioning option in database?.
I should have mentioned that my comments were for UNIX platform. I recommend calling Oracle Support to see if there are equivalent commands for NT platform. Gerardo -Original Message- Sent: Thursday, November 29, 2001 6:30 AM To: Multiple recipients of list ORACLE-L 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- Sent: Wednesday, November 28, 2001 8:33 PM To: Multiple recipients of list ORACLE-L 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 <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). -- 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).
RE: enable the partitioning option in database?.
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).
Enable the partitioning option in database?.
Title: Enable the partitioning option in database?. -Original Message- From: Nirmal Kumar Muthu Kumaran Sent: Wednesday, November 28, 2001 4:56 PM To: '[EMAIL PROTECTED]' Subject: enable the partitioning option in database?. 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.
RE: enable the partitioning option in database?.
what do you do for NT ? -Original Message- Sent: Wednesday, November 28, 2001 9:33 AM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prakriteswar Santikary 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).
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).
RE: enable the partitioning option in database?.
Title: RE: enable the partitioning option in database?. In addition, one needs to have License to use Partitioning. - Kirti -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001 9:31 AMTo: Multiple recipients of list ORACLE-LSubject: RE: enable the partitioning option in database?. Go through the installer again and install the partitioning option. By the way you have to be running Enterprise Edition. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 8:56 AM To: Multiple recipients of list ORACLE-L Subject: enable the partitioning option in database?. hI GURUS' How can i enable the partitioning option in database?. Any idea? [EMAIL PROTECTED]> SELECT PARAMETER, VALUE FROM V$OPTION WHERE VALUE='FALSE'; PARAMETERVALUEPartitioningFALSE Parallel ServerFALSE JavaFALSE Rgds,Nirmal.
RE: enable the partitioning option in database?.
Nirmal - Don't forget that partitioning is an extra-pay item beyond EE licensing. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
Re: enable the partitioning option in database?.
Nirmal, That option is loaded and installed from the source CD using the GUI installer program. I think it is only available on the EE and there is a co$t. ROR mª¿ªm >>> [EMAIL PROTECTED] 11/28/01 08:55AM >>> 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: Ron Rogers 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).
RE: enable the partitioning option in database?.
Title: RE: enable the partitioning option in database?. Go through the installer again and install the partitioning option. By the way you have to be running Enterprise Edition. Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 8:56 AM To: Multiple recipients of list ORACLE-L Subject: enable the partitioning option in database?. 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.
enable the partitioning option in database?.
Title: enable the partitioning option in database?. 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.