Pages

Tuesday, December 6, 2022

ORA-14602: SUBPARTITION TEMPLATE is legal only for a composite partitioned table

ORA-14602: SUBPARTITION TEMPLATE is legal only for a composite partitioned table
One cannot do TEMPLATE SUBPARTITION to a table that was not Composite Partitioned.

Composite Partitioned, meaning
PARTITION BY RANGE.
This is opposed to PARTITION BY LIST.

How to tell:
SELECT DISTINCT table_name, composite 
  FROM USER_TAB_PARTITIONS 
ORDER BY table_name;

 
TABLE_NAME                     COMPOSITE
------------------------------ ------------
GA_W_COUNTERS_HISTORY          NO
REP_DAILY_DNORM                YES
REP_MONTHLY_DNORM              YES
SFI_CUSTOMER_OPTIONS           NO
SFI_CUSTOMER_PROFILE           NO
SFI_CUSTOMER_PROFILE_TMP       NO
SFI_CUSTOMER_USAGE             NO
SFI_CUSTOMER_USAGE_HOURLY      NO
SFI_CUSTOMER_USAGE_HOURLY_TMP  NO
SFI_VISITOR_PROFILE            NO
SGA_SUBSCRIBER_SFI             NO
SGA_SUBSCRIBER_SFI_B           NO
SGA_W_IPN_SUBSCRIBER           YES
SGA_W_MAJOR_EVENTS             NO
SGA_W_MOCO_SUBSCRIBER          YES
SGA_W_MOCO_VISITOR             YES
SGA_W_PSMS_SUBSCRIBER          YES
SWMS_SUBSCRIBER                YES

No comments:

Post a Comment