That's the easy part. The tough part is to figure out wether or not it's licensed: SQL> SELECT * FROM my_oracle_salesman; select * from my_oracle_salesman * ERROR at line 1: ORA-00942: table or view does not exist Hmmm... ;) Rich ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Satheesh Babu Sent: Wednesday, September 13, 2006 9:19 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Oracle Partitioning 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