IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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/
