Database DataWarehousing (MOSC)

MOSC Banner

Enabling Oracle table partition in 11g

edited Sep 26, 2013 7:42AM in Database DataWarehousing (MOSC) 4 commentsAnswered
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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center