Site icon IT Tutorial

ORA-14004: missing PARTITION keyword


Sometimes you can get  “ORA-14004: missing PARTITION keyword  ” error.


Details of error are as follows.

ORA-14004: missing PARTITION keyword

Cause: keyword PARTITION missing
Action: supply missing keyword

DBMS_REDEFINITION  will create huge index during the redefinition on the Interim Table

and will Fail with Ora-14004:missing PARTITION keyword



To solve this error, Download  and apply  patch 17561400 on top of


The latest Patchset for 11gR2 where this fix will be included .


Or You should supply missing keyword in the Add Partition script.


Do you want to learn Oracle Database for Beginners, then read the following articles.

 1,942 views last month,  1 views today

Exit mobile version