Trying to create this index partition
CREATE INDEX bb_bb60_stats.activity_acc
ON bb_bb60_stats.activity_acc
CREATE INDEX bb_bb60_stats.activity_acc
ON bb_bb60_stats.activity_acc
(
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?
CREATE INDEX bb_bb60_stats.activity_acc
ON bb_bb60_stats.activity_acc
CREATE INDEX bb_bb60_stats.activity_acc
ON bb_bb60_stats.activity_acc
(
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?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 13 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 13 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.