SQL> Select * from v$option where parameter='Partitioning'; PARAMETER VALUE ---------------------------------------- ---------- Partitioning TRUE SQL> Regards, Satheesh Babu.S -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of edwin devadanam Sent: Thursday, September 14, 2006 3:35 AM 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 <http://us.rd.yahoo.com/evt=42297/*http:/advision.webevents.yahoo.com/mailbe ta> Yahoo! Mail.