Oracle DBA, How To, Error, Cause and Action

ORA-14604: During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified

ORA-14604: During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified


Cause:


Once a subpartition template has been specified during a CREATE TABLE it is illegal to specify SUBPARTITIONS or STORE IN anywhere else



Action:


Remove either the SUBPARTITIONS | STORE IN or remove the SUBPARTITION TEMPLATE clause

No comments:

Post a Comment

Thanks for your comment.