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.
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
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