ORA-14070: option may be specified only for partitioned
indices or with REBUILD
- 1 Answers
- 2343 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: User issued ALTER INDEX statament containing an
option which is legal only for partitioned indices or in
conjunction with REBUILD against a non-partitioned index.
Such options are: PCTFREE, TABLESPACE, [NO]PARALLEL and
INITIAL, FREELISTS, and FREELIST GROUPS inside STORAGE clause
Action: Remove illegal option(s).
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
RMAN-06055: could not find log sequence string thread string
PLS-00598: comparison of object with NULL using "string" is not allowed
ORA-06572: Function string has out arguments
QSM-01131: query has ONLY_MULTIMV_REWRITE hint
ORA-03246: Invalid block number specified
DRG-12016: The target document for this operation has moved - continue?
DRG-12018: Encountered an automatic request for changing proxy - continue?
NNL-00276: Trace level is now number
PLS-00351: Not logged onto database 'string'
ORA-14115: partition bound of partition number string is too long
ORA-19506: failed to create sequential file, name="string", parms="string"
ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
Oracle Errors 
