Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14064: Index with Unusable partition exists on
unique/primary constraint key
- 1 Answers
- 5031 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: User attempted to add or enable a primary key/unique
constraint on column(s) of a table on which there exists an
index one or more partitions of which are marked Index Unusable.
Action: Drop the existing index or rebuild unusable
partitions it using ALTER INDEX REBUILD PARTITION
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-30770: Cannot specify storage options for fixed size opaque type
ORA-09211: sfwfb: error writing to file
ORA-02333: cannot create constraints on attributes of this column
ORA-16802: downgrading log transport mode from SYNC disallowed
ORA-39032: function string is not supported in string jobs
PLS-01416: Use of <id> (<value>...) here
ORA-29250: Invalid index specifed in call to dbms_sql.bind_array
NNL-00236: Statistic counter reset interval is currently string
PLS-00737: LIBRARY file specification exceeds the maximum allowed length
ORA-29399: user string does not have privilege to switch to consumer group string
ORA-02216: tablespace name expected
PCC-00085: Error writing to file string
Oracle Errors 
