Database DataWarehousing (MOSC)

MOSC Banner

Syntax Error while Creating Partition with MOD Function

edited Apr 18, 2013 10:17PM in Database DataWarehousing (MOSC) 5 commentsAnswered ✓
 Hi, 
I am trying to create a MOD Based Partition table, but getting a syntax error. Can someone help me ?


CREATE TABLE PAR_MODU
(
   A1   NUMBER (22) NOT NULL,
   B1   NUMBER (22) NOT NULL
)
PARTITION BY RANGE (MOD(A1,10)
   (PARTITION P1 VALUES LESS THAN 1));


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