Edwin, You can always login with SqlPlus and look at the banner: Tom SQL*Plus: Release 9.2.0.1.0 - Production on Thu Sep 14 08:51:28 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production SQL> -------------------------------------------------------- This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of edwin devadanam Sent: Wednesday, September 13, 2006 6:05 PM To: oracle-l@xxxxxxxxxxxxx Subject: Oracle Partitioning Hi , In 9.2.0.5 oracle database on windows,how to know whether Oracle Partitioning is enabled/installed. Any query to know from database side........ Thanks, Edwin.K ________________________________ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. <http://us.rd.yahoo.com/evt=42297/*http:/advision.webevents.yahoo.com/ma ilbeta>