ORA-02158: invalid CREATE INDEX option
Answer / guest
Cause: An option other than COMPRESS, NOCOMPRESS, PCTFREE,
INITRANS, MAXTRANS, STORAGE, TABLESPACE, PARALLEL,
NOPARALLEL, RECOVERABLE, UNRECOVERABLE, LOGGING, NOLOGGING,
LOCAL, or GLOBAL was specified.
Action: Choose one of the valid CREATE INDEX options.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 1 No |
PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL
ORA-30015: previously offlined undo tablespace 'string' is still pending
ORA-12481: effective label not within program unit clearance range
LPX-00108: parameter-entity parenthetical cannot be split up
QSM-00787: the tablespace string is invalid for directive string
ORA-06952: Remote end of the communication issued a forward-reset packet.
ORA-25298: The memory threshold for a queue cannot be negative
Recent I have migrated oracle9i to oracle10g(10.2.0.3). I have nested table that table used user define datatype. at a column. when i want to input the valoue at this column ,i cann't the input value.following the error messasge i have got: ORA-24328 illegal attribute value
ORA-01631: max # extents (string) reached in table string.string
RMAN-06720: file "string" removed from catalog
ORA-32631: illegal use of objects in MODEL
ORA-25258: cannot register for notifications on an 8.0 style exception queue