Oracle7 Server Messages

Contents Index Home Previous Next

25100-25199: Parse Errors

ORA-25100 TABLESPACE option can only be used with ALTER INDEX REBUILD

Cause:The TABLESPACE option to ALTER INDEX was used without the REBUILD option.
Action:Use ALTER INDEX REBUILD TABLESPACE <tablespace name>.

ORA-25101 duplicate REBUILD option specification

Cause:The REBUILD option to ALTER INDEX was specified more than once.
Action:Specify the option at most once.

ORA-25102 PARALLEL option can only be used with ALTER INDEX REBUILD

Cause:The PARALLEL option to ALTER INDEX was used without the REBUILD option.
Action:Use ALTER INDEX REBUILD.

ORA-25103 NOPARALLEL option can only be used with ALTER INDEX REBUILD

Cause:The NOPARALLEL option to ALTER INDEX was used without the REBUILD option.
Action:Use ALTER INDEX REBUILD.

ORA-25104 UNRECOVERABLE option can only be used with ALTER INDEX REBUILD

Cause:The UNRECOVERABLE option to ALTER INDEX was used without the REBUILD option.
Action:Use ALTER INDEX REBUILD.

ORA-25105 RECOVERABLE option can only be used with ALTER INDEX REBUILD

Cause:The RECOVERABLE option to ALTER INDEX was used without the REBUILD option.
Action:Use ALTER INDEX REBUILD.

ORA-25106 only one of PARALLEL or NOPARALLEL clause may be specified

Cause:PARALLEL was specified more than once, NOPARALLEL was specified more than once, or both PARALLEL and NOPARALLEL were specified in an ALTER INDEX REBUILD statement.
Action:Remove all but one of the PARALLEL or NOPARALLEL clauses.

ORA-25107 duplicate TABLESPACE option specification

Cause:The TABLESPACE was specified more than once in an ALTER INDEX REBUILD statement.
Action:Remove all but one of the TABLESPACE clauses.

ORA-25108 standby lock name space exceeds size limit of num characters

Cause:The lock name space for the standby database exceeded the maximum string length.
Action:Change initialization parameter STANDBY_LOCK_NAME_SPACE to a character string of less than the specified characters.

ORA-25109 standby lock name space has illegal character char

Cause:An invalid lock name space was specified for the standby database. The lock name space for the standby database can only contain A-Z, 0-9, '_', '#', '$', and '@' characters.
Action:Change initialization parameter STANDBY_LOCK_NAME_SPACE to a valid character string.

ORA-25110 NOSORT may not be used with a bitmap index

Cause:An attempt was made to create a bitmap index using the NOSORT option.
Action:Remove NOSORT from the CREATE BITMAP INDEX statement.

ORA-25111 BITMAP may not be used with a cluster index

Cause:An attempt was made to create a cluster index the the BITMAP attribute.
Action:Remove BITMAP from the CREATE INDEX statement.

ORA-25112 a bitmap index may index only one column

Cause:An attempt was made to create a bitmap index on more than one column.
Action:Remove all columns in the CREATE INDEX statement except one.

ORA-25113 DML operations for BITMAP indexes not implemented

Cause:A DML operation such as INSERT, UPDATE, DELETE was performed on a table that has at least one BITMAP index defined.
Action:Remove all BITMAP indexes defined on the table.


Contents Index Home Previous Next