Release 8.0.4
A58312-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8 Error Messages Release 8.0.4 A58312-01 |
|
Cause: The TABLESPACE option to ALTER INDEX was used without the REBUILD option.
Action: Use ALTER INDEX REBUILD TABLESPACE <tablespace name>.
For more information about ALTER INDEX and other options in CREATE INDEX, see the index entries on "ALTER INDEX" and on "CREATE INDEX" in Oracle8 Server SQL Reference.
Cause: The REBUILD option to ALTER INDEX was specified more than once.
Action: Specify the option at most once.
For more information about ALTER INDEX and other options in CREATE INDEX, see the index entries on "ALTER INDEX" and on "CREATE INDEX" in Oracle8 Server SQL Reference.
Cause: The PARALLEL option to ALTER INDEX was used without the REBUILD option.
Action: Use ALTER INDEX REBUILD.
For more information about ALTER INDEX and other options in CREATE INDEX, see the index entries on "ALTER INDEX" and on "CREATE INDEX" in Oracle8 Server SQL Reference.
Cause: The NOPARALLEL option to ALTER INDEX was used without the REBUILD option.
Action: Use ALTER INDEX REBUILD.
For more information about ALTER INDEX and other options in CREATE INDEX, see the index entries on "ALTER INDEX" and on "CREATE INDEX" in Oracle8 Server SQL Reference.
Cause: The UNRECOVERABLE option to ALTER INDEX was used without the REBUILD option.
Action: Use ALTER INDEX REBUILD.
For more information about ALTER INDEX and other options in CREATE INDEX, see the index entries on "ALTER INDEX," "UNRECOVERABLE," and "CREATE INDEX" in Oracle8 Server SQL Reference.
Cause: The RECOVERABLE option to ALTER INDEX was used without the REBUILD option.
Action: Use ALTER INDEX REBUILD.
For more information about ALTER INDEX and other options in CREATE INDEX, see the index entries on "ALTER INDEX" and on "CREATE INDEX" in Oracle8 Server SQL Reference.
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.
For more information about ALTER INDEX and other options in CREATE INDEX, see the index entries on "ALTER INDEX" and on "CREATE INDEX" in Oracle8 Server SQL Reference.
Cause: The TABLESPACE was specified more than once in an ALTER INDEX REBUILD statement.
Action: Remove all but one of the TABLESPACE clauses.
For more information about ALTER INDEX and the TABLESPACE option in CREATE INDEX, see the index entries on "ALTER INDEX" and on "CREATE INDEX" in Oracle8 Server SQL Reference.
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.
For more information about standby databases, see the index entries on "standby database" in the Oracle8 Server Administrator's Guide.
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.
For more information about standby databases, see the index entries on "standby database" in the Oracle8 Server Administrator's Guide.
Cause: An attempt was made to create a bitmap index using the NOSORT option.
Action: Remove NOSORT from the CREATE BITMAP INDEX statement.
For more information about the NOSORT option, see the index entry on "NOSORT option, of CREATE INDEX command" in Oracle8 Server SQL Reference.
Cause: An attempt was made to create a cluster index the BITMAP attribute.
Action: Remove BITMAP from the CREATE INDEX statement.
For more information about the CREATE INDEX command, see the index entry on "CREATE INDEX command" in Oracle8 Server SQL Reference.
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.
For more information about the CREATE INDEX command, see the index entry on "CREATE INDEX command" in Oracle8 Server SQL Reference.
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.
For more information about the CREATE INDEX command, see the index entry on "CREATE INDEX command" in Oracle8 Server SQL Reference.
Cause: A file number used in dumping a data file is invalid.
Action: Specify a valid file number.
Cause: BLOCK (MIN/MAX) is specified more than once in DUMP DATAFILE command.
Action: Choose one BLOCK option and specify it.
Cause: A block number used in dumping a data file is invalid.
Action: Specify a valid block number.
Cause: MIN/MAX, or block number is expected in the DUMP DATAFILE command.
Action: Correct the syntax and retry.
Cause: Invalid option specified for DUMP DATAFILE command.
Action: Correct the syntax and retry.
Cause: In CREATE TABLESPACE, the LOGGING and/or NOLOGGING options were specified more than once.
Action: Remove all but one of the logging specifications.
Cause: In CREATE TABLESPACE, the MINIMUM EXTENT option is specified more than once.
Action: Remove all but one of the MINIMUM EXTENT specifications.
Cause: In CREATE/ALTER TABLESPACE, value specified for MINIMUM EXTENT option is greater than the maximum extent size.
Action: Decrease the value specified for MINIMUM EXTENT option.
Cause: An attempt was made to create a global bitmap index on a partitioned table.
Action: Create a local bitmap index instead. Then retry the operation.
Cause: Specifying more components to a name than allowed.
Action: Check the name specified for the operation.
Cause: Specifying a database link name when it is not permitted.
Action: Check the name specified for the operation.
Cause: An attempt was made to specify the BUFFER_POOL storage option. This option may only be specified during CREATE/ALTER TABLE/CLUSTER/INDEX.
Action: Remove this option and retry the statement.
Cause: The name of the buffer pool specified by the user is invalid. The only valid names are KEEP, RECYCLE and DEFAULT.
Action: Use a valid name or remove the BUFFER_POOL clause.
Cause: A PRIMARY KEY constraint must be defined for a table with this organization.
Action: Define a PRIMARY KEY and retry the operation.
Cause: Storage parameters cannot be defined for a PRIMARY KEY constraint for a table with this organization.
Action: Remove storage specification for primary key.
Cause: The UNRECOVERABLE option might not be specified for a primary key for a table with this organization.
Action: Remove UNRECOVERABLE option for primary key.
Cause: The storage option PCTTHRESHOLD is specified more than once.
Action: Specify storage options at most once.
Cause: The specified value must be a positive integer.
Action: Specify an appropriate value.
Cause: PCTTHRESHOLD can only be specified for tables with certain organizations.
Action: Remove the PCTTHRESHOLD option.
Cause: ON keyword required to specify nested index column nest.
Action: Add ON keyword and retry the operation
Cause: An attempt was made to use one or more of the following feature(s) not currently supported for index-organized tables:
Action: Do not use the disallowed feature(s) in this release.
Cause: An attempt was made to drop a tablespace which contains an index only table's overflow segment but not the top index segment.
Action: Find index-organized tables which span the tablespace being dropped and some other tablespace(s). Drop these tables.
Cause: A column name is not present where required by the CREATE TABLE for specifying last column to be included in the index segment of the index-organized table.
Action: Specify a column name where required by the syntax.
Cause: While creating index-only tables, an index column name, instead of a non-index column name, was used for the INCLUDING clause of a CREATE TABLE statement used for creating index-organized tables .
Action: Specify a column name which is not part of index-organized table top index for the INCLUDING clause.
Cause: The INCLUDING clause of a CREATE TABLE is a valid option only for index-organized tables with OVERFLOW clause.
Action: Specify an OVERFLOW clause for the index-organized table.
Cause: The specified table does not have the proper field definitions.
Action: Specify the correct table to use.
Cause: An attempt was made to DROP, DISABLE, or DEFER the primary key constraint for an index-only table. This is not allowed.
Action: This is an informational message. Do not DROP, DISABLE, or DEFER the primary key constraint for an index-only table.
Cause: During ALTER of a index-organized table, the user attempted to enter one or more of the following options: TABLESPACE, ALLOCATE/DEALLOCATE EXTENT, PCTFREE/PCTUSED for IOT top index segment.
Action: Remove the illegal option(s).
Cause: ALTER TABLE statement attempted to combine an index-organized table maintenance operation (e.g. changing physical attributes) with some other operation (e.g. ADD constraint) which is illegal.
Action: Ensure that a index-organized table maintenance operation is the sole operation specified in ALTER TABLE statement.
Cause: An attempt was made to directly access the overflow table of an index-organized tabl.
Action: Issue the statement against the parent index-organized table containing the specified overflow table.
Cause: An attempt was made to specify one or more of the following options for an index-organized table: [NO]CACHE, NO LOGGING, CLUSTER
Action: Remove the invalid option(s).
