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@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

Other related posts: