Enabling Oracle table partition in 11g
We have 7 oracle databases running from the same 11.1.0 oracle home. Please provide me the steps to enable Oracle table partition in 11g.
I am able to check if partitioning is enable or not at database level, but how to check it at OS level ?
SYS AS SYSDBA at oa007 >select * from v$option where parameter = 'Partitioning';
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Partitioning
FALSE
How many licenses will I be using to enable this feature in our environment with 7 databases running from same 11.1.0.7 home ? Is it one oracle table partitioning license for one single database ? or Is it counted as one per one oracle home ?
I am able to check if partitioning is enable or not at database level, but how to check it at OS level ?
SYS AS SYSDBA at oa007 >select * from v$option where parameter = 'Partitioning';
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Partitioning
FALSE
How many licenses will I be using to enable this feature in our environment with 7 databases running from same 11.1.0.7 home ? Is it one oracle table partitioning license for one single database ? or Is it counted as one per one oracle home ?
0