Site icon IT Tutorial

ORA-14004: missing PARTITION keyword

Hi,

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 11.2.0.3

Or

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.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 1,942 views last month,  1 views today

Exit mobile version