Oracle Database Error Code ORA-14004 Description :
missing PARTITION keyword
Error Cause:
keyword PARTITION missing
How to Solve :
supply missing keyword
Search Oracle Error Codes and Descriptions:
1 Comment Already
Similar Errors
- Oracle database error code ORA-29957 – cannot create a function-based domain index on a string table
- Oracle database error code ORA-31600 – invalid input value string for parameter string in function string
- Oracle database error code ORA-29958 – fatal error occurred in the execution of ODCIINDEXCREATE routine
- Oracle database error code ORA-31601 – Function string cannot be called now that fetch has begun.
- Oracle database error code ORA-29959 – error in the execution of the string routine for one or more of the index partitions
Pathetic explanation. Doesn’t explain the root cause, neither any in detail information.
I got it for the following clause in 11g:
CREATE TABLE test_hst (
BATCHNUM1 DECIMAL(30) NOT NULL,
text VARCHAR2(4) NOT NULL)
PARTITION BY RANGE (BATCHNUM1)
INTERVAL(4)
(
PARTITION psarch1 VALUES less than (5),
PARTITION psarch2 VALUES less than (9),
);