RE: Oracle Partitioning

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Satheesh Babu
Sent: Wednesday, September 13, 2006 9:19 PM To: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of edwin devadanam
Sent: Thursday, September 14, 2006 3:35 AM To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l