Trying to create this index partition
CREATE INDEX bb_bb60_stats.activity_accumulator_iecontent
ON bb_bb60_stats.activity_accumulator (content_pk1) LOCAL;
CREATE INDEX bb_bb60_stats.activity_accumulator_iecontent
ON bb_bb60_stats.activity_accumulator (content_pk1) LOCAL
(
PARTITION aa_2010_04 TABLESPACE BB_BB60_STATS_INDX,
PARTITION aa_2010_05 TABLESPACE BB_BB60_STATS_INDX,
PARTITION aa_2010_06 TABLESPACE BB_BB60_STATS_INDX,
PARTITION aa_2010_07 TABLESPACE BB_BB60_STATS_INDX,
Getting the message
"Index created.
PARTITION AA_2010_04 TABLESPACE BB_BB60_STATS_DATA
*
ERROR at line 5:
ORA-14010: this physical attribute may not be specified for an index partition
"
What attribute am I specifying that I should not?
Oracle in general doesn't like two things of the same type in the database with the same name.
(Unless something about partitioning requires you to do it this way, but nothing I could find in the documentation suggested that)