分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！
ORA-02140 to ORA-04099 5
ORA-02140: invalid tablespace name
Cause: An identifier does not follow ALTER TABLESPACE.
Action: Specify a tablespace name following ALTER TABLESPACE.
ORA-02141: invalid OFFLINE option
Cause: An option other than NORMAL or IMMEDIATE follows OFFLINE.
Action: The user must either specify no option following OFFLINE or one of the
options NORMAL or IMMEDIATE.
ORA-02142: missing or invalid ALTER TABLESPACE option
Cause: A valid option was not present.
Action: Use one of the valid options: add, rename, default, online, offline, read
only, read write, begin, end, no, force, retention guarantee and retention
noguarantee.
ORA-02143: invalid STORAGE option
Cause: An option other than INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, or
PCTINCREASE was specified in the STORAGE clause.
Action: Specify only valid options.
ORA-02144: no option specified for ALTER CLUSTER
Cause: No ALTER CLUSTER options are specified.
Action: Specify one or more of the following options: pctfree, pctused, size,
storage.
ORA-02145: missing STORAGE option
Cause: No STORAGE options were specified following STORAGE (
Action: Specify one or more STORAGE option between the parentheses.
ORA-02146: SHARED specified multiple times
Cause: The SHARED option was specified in a CREATE DATABASE statement
multiple times.
Action: Only specify the SHARED option once.
ORA-02147: conflicting SHARED/EXCLUSIVE options
Cause: Both the SHARED and EXCLUSIVE options were specified in a CREATE
DATABASE statement.
Action: Specify SHARED or EXCLUSIVE, but not both.
5-2 Oracle Database Error Messages
ORA-02148: EXCLUSIVE specified multiple times
Cause: The EXCLUSIVE option was specified in a CREATE DATABASE statement
multiple times.
Action: Only specify the EXCLUSIVE option once.
ORA-02149: Specified partition does not exist
Cause: Partition not found for the object.
Action: Retry with correct partition name.
ORA-02150: invalid new tablespace name
Cause: The new tablespace name specified in ALTER TABLESPACE RENAME TO
statement was invalid.
Action: Retry with a valid new tablespace name.
ORA-02151: invalid tablespace name: string
Cause: Oracle cannot create a tablespace whose name starts with '_$deleted$'.
Action: Try a different tablespace name.
ORA-02152: Invalid ALTER TABLESPACE ... RENAME option
Cause: An option other than DATAFILE or TO follows by ALTER TABLESPACE
... RENAME.
Action: The user must specify either DATAFILE or TO following ALTER
TABLESPACE ... RENAME.
ORA-02153: invalid VALUES password string
Cause: An encoded password string does not follow the VALUES clause.
Action: Place a proper encoded password string after the VALUES clause.
ORA-02154: a tablespace with the name 'string' is found
Cause: An attempt to rename a tablespace to a new name failed because the new
name is already used by some other tablespace.
Action: Retry with a different new name.
ORA-02155: invalid DEFAULT tablespace identifier
Cause: An identifier does not follow DEFAULT TABLESPACE.
Action: Place a tablespace name after DEFAULT TABLESPACE.
ORA-02156: invalid TEMPORARY tablespace identifier
Cause: An identifier does not follow TEMPORARY TABLESPACE.
Action: Place a tablespace name after TEMPORARY TABLESPACE.
ORA-02157: no options specified for ALTER USER
Cause: No options were specified.
Action: Specify at least one ALTER USER option.
ORA-02158: invalid CREATE INDEX option
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.
ORA-02140 to ORA-04099 5-3
ORA-02159: installed DLM does not support releasable locking mode
Cause: The parameter file specified gc_* parameters that allow locks to be release
by the LCK process when not in use. This mode requires additional support from
the DLM that is not available.
Action: Specify configuration parameters that do not require the additional
function.
ORA-02160: index-organized table can not contain columns of type LONG
Cause: A column of type LONG defined for index-organized table.
Action: Do not use columns of type LONG in index-organized tables.
ORA-02161: invalid value for MAXLOGFILES
Cause: A number does not follow MAXLOGFILES.
Action: Specify a number after MAXLOGFILES.
ORA-02162: invalid value for MAXDATAFILES
Cause: A number does not follow MAXDATAFILES.
Action: Specify a number after MAXDATAFILES.
ORA-02163: invalid value for FREELIST GROUPS
Cause: A number does not follow FREELIST GROUPS.
Action: Specify a number after FREELIST GROUPS.
ORA-02164: DATAFILE clause specified more than once
Cause: The CREATE DATABASE command contains more than one DATAFILE
clause.
Action: Specify at most one DATAFILE clause.
ORA-02165: invalid option for CREATE DATABASE
Cause: An invalid CREATE DATABASE option is present.
Action: Specify only valid CREATE DATABASE options.
ORA-02166: ARCHIVELOG and NOARCHIVELOG specified
Cause: Both ARCHIVELOG and NOARCHIVELOG are specified in a CREATE
DATABASE statement.
Action: Specify at most one of these two options.
ORA-02167: LOGFILE clause specified more than once
Cause: The CREATE DATABASE command contains more than one LOGFILE
clause.
Action: Specify at most one LOGFILE clause.
ORA-02168: invalid value for FREELISTS
Cause: A number does not follow FREELISTS
Action: Specify a number after FREELISTS
ORA-02169: FREELISTS storage option not allowed
Cause: The user attempted to specify the FREELISTS storage option. This option
may only be specified during create table or create index.
Action: Remove these options and retry the statement.
ORA-02170: FREELIST GROUPS storage option not allowed
5-4 Oracle Database Error Messages
Cause: The user attempted to specify the FREELIST GROUPS storage option. This
option may only be specified during create table and when allow_freelist_groups
INIT.ORA is specified.
Action: Remove this option and retry the statement or set the allow_freelist_
groups INIT.ORA parameter.
ORA-02171: invalid value for MAXLOGHISTORY
Cause: A number does not follow MAXLOGHISTORY
Action: Specify a number after MAXLOGHISTORY
ORA-02172: The PUBLIC keyword is not appropriate for a disable thread
Cause: The PUBLIC keyword was specified for a disable.
Action: Remove the keyword and resubmit.
ORA-02173: invalid option for DROP TABLESPACE
Cause: Either a token other than INCLUDING was found following the
tablespace name or some text was found following INCLUDING CONTENTS.
Action: Place nothing or only INCLUDING CONTENTS after the tablespace
name.
ORA-02174: Missing required thread number
Cause: Must specify thread number after THREAD keyword
Action: None
ORA-02175: invalid rollback segment name
Cause: In the CREATE or DROP ROLLBACK SEGMENT statements, an identifier
was not found following ROLLBACK SEGMENT.
Action: Place the segment name following ROLLBACK SEGMENT.
ORA-02176: invalid option for CREATE ROLLBACK SEGMENT
Cause: An invalid option was specified in a CREATE ROLLBACK SEGMENT
statement.
Action: Specify one of the valid options: TABLESPACE and STORAGE.
ORA-02177: Missing required group number
Cause: Must specify group number after GROUP keyword
Action: None
ORA-02178: correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
Cause: There is a syntax error in the user's statement.
Action: Correct the syntax as indicated.
ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ
COMMITTED }
Cause: There is a syntax error in the user's statement.
Action: Correct the syntax as indicated.
ORA-02180: invalid option for CREATE TABLESPACE
Cause: An invalid option appeared.
Action: Specify one of the valid options: DATAFILE, DEFAULT STORAGE,
ONLINE, OFFLINE, FORCE, RETENTION.
ORA-02140 to ORA-04099 5-5
ORA-02181: invalid option to ROLLBACK WORK
Cause: A token other than TO follows ROLLBACK [WORK].
Action: Place nothing or TO SAVEPOINT <name> after ROLLBACK [WORK].
ORA-02182: savepoint name expected
Cause: An identifier does not follow ROLLBACK [WORK] TO [SAVEPOINT].
Action: Place a savepoint name following TO [SAVEPOINT].
ORA-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE | READ
COMMITTED }
Cause: There is a syntax error in the user's statement.
Action: Correct the syntax as indicated.
ORA-02184: resource quotas are not allowed in REVOKE
Cause: In a revoke statement, a resource quota was specified.
Action: Specify resource privilege without the quota.
ORA-02185: a token other than WORK follows COMMIT
Cause: A token other than WORK follows COMMIT.
Action: Place either nothing or WORK after COMMIT.
ORA-02186: tablespace resource privilege may not appear with other privileges
Cause: An attempt was made to grant or revoke a resource quota in the same
statement in which other privileges are granted or revoked.
Action: Use a separate grant or revoke statement for the resource quota privilege.
ORA-02187: invalid quota specification
Cause: In a grant or revoke statement, the user attempted to grant a tablespace
quota above the upper limit.
Action: Grant a smaller tablespace quota.
ORA-02188: Cannot enable instance publicly
Cause: An attempt was made to publicly enable a thread associated with an
instance.
Action: Leave out the PUBLIC keyword.
ORA-02189: ON <tablespace> required
Cause: In a grant or revoke statement, the user specified a tablespace quota but
did not follow it with the ON <tablespace> clause.
Action: Specify the tablespace on which the quota is to be applied with the ON
<tablespace> clause.
ORA-02190: keyword TABLES expected
Cause: The keyword TABLES is expected following DROP CLUSTER <name>
INCLUDING.
Action: Place TABLES after INCLUDING.
ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT
<rbs>
Cause: There is a syntax error in the user's statement.
Action: Correct the syntax as indicated.
5-6 Oracle Database Error Messages
ORA-02192: PCTINCREASE not allowed for rollback segment storage clauses
Cause: pctincrease was specified in a create or alter rollback segment
Action: reissue statement without the pctincrease clause
ORA-02194: event specification syntax error string (minor error string) near 'string'
Cause: There is a syntax error in an event specification.
Action: Fix the error.
ORA-02195: Attempt to create string object in a string tablespace
Cause: The object type is inconsistent with a tablespace contents.
Action: Create an object in a different tablespace, or change the user defaults.
ORA-02196: PERMANENT/TEMPORARY option already specified
Cause: In CREATE TABLESPACE, the PERMANENT and/or TEMPORARY
options were specified more than once.
Action: None
ORA-02197: file list already specified
Cause: In CREATE TABLESPACE, more than one DATAFILE/TEMPFILE clause
was specified.
Action: Merge the DATAFILE/TEMPFILE clauses into a single clause.
ORA-02198: ONLINE/OFFLINE option already specified
Cause: In CREATE TABLESPACE, the ONLINE and/or OFFLINE options were
specified more than once.
Action: Specify at most one of ONLINE or OFFLINE.
ORA-02199: missing DATAFILE/TEMPFILE clause
Cause: A CREATE TABLESPACE statement has no DATAFILE/TEMPFILE clause.
Action: Specify a DATAFILE/TEMPFILE clause.
ORA-02200: WITH GRANT OPTION not allowed for PUBLIC
Cause: An attempt was made to GRANT to PUBLIC WITH GRANT OPTION.
Action: Remove the WITH GRANT OPTION clause.
ORA-02201: sequence not allowed here
Cause: An attempt was made to reference a sequence in a from-list.
Action: A sequence can only be referenced in a select-list.
ORA-02202: no more tables permitted in this cluster
Cause: An attempt was made to create a table in a cluster which already contains
32 tables.
Action: Up to 32 tables may be stored per cluster.
ORA-02203: INITIAL storage options not allowed
Cause: The user attempted to alter the INITIAL storage option of a table, cluster,
index, or rollback segment. These options may only be specified when the object is
created.
Action: Remove these options and retry the statement.
ORA-02204: ALTER, INDEX and EXECUTE not allowed for views
ORA-02140 to ORA-04099 5-7
Cause: An attempt was made to grant or revoke an invalid privilege on a view.
Action: Do not attempt to grant or revoke any of ALTER, INDEX, or EXECUTE
privileges on views.
ORA-02205: only SELECT and ALTER privileges are valid for sequences
Cause: An attempt was made to grant or revoke an invalid privilege on a
sequence.
Action: Do not attempt to grant or revoke DELETE, INDEX, INSERT, UPDATE,
REFERENCES or EXECUTE privilege on sequences.
ORA-02206: duplicate INITRANS option specification
Cause: INITRANS is specified more than once.
Action: Specify INITRANS at most once.
ORA-02207: invalid INITRANS option value
Cause: The INITRANS value is not an integer between 1 and 255 and less than or
equal to the MAXTRANS value.
Action: Choose a valid INITRANS value.
ORA-02208: duplicate MAXTRANS option specification
Cause: MAXTRANS is specified more than once.
Action: Specify MAXTRANS at most once.
ORA-02209: invalid MAXTRANS option value
Cause: The MAXTRANS value is not an integer between 1 and 255 and greater
than or equal to the INITRANS value.
Action: Choose a valid MAXTRANS value.
ORA-02210: no options specified for ALTER TABLE
Cause: No ALTER TABLE option was specified.
Action: Specify at least one alter table option.
ORA-02211: invalid value for PCTFREE or PCTUSED
Cause: The specified value for PCTFREE or PCTUSED is not an integer between 0
and 100.
Action: Choose an appropriate value for the option.
ORA-02212: duplicate PCTFREE option specification
Cause: PCTFREE option specified more than once.
Action: Specify PCTFREE at most once.
ORA-02213: duplicate PCTUSED option specification
Cause: PCTUSED option specified more than once.
Action: Specify PCTUSED at most once.
ORA-02214: duplicate BACKUP option specification
Cause: The BACKUP option to ALTER TABLE is specified more than once.
Action: Specify the option at most once.
ORA-02215: duplicate tablespace name clause
Cause: There is more than one TABLESPACE clause in the CREATE TABLE,
CREATE INDEX, or CREATE ROLLBACK SEGMENT statement.
5-8 Oracle Database Error Messages
Action: Specify at most one TABLESPACE clause.
ORA-02216: tablespace name expected
Cause: A tablespace name was not present where required by the syntax for the
failing statement.
Action: Specify a tablespace name where required by the syntax.
ORA-02217: duplicate storage option specification
Cause: A storage option (INIITAL, NEXT, MINEXTENTS, MAXEXTENTS,
PCTINCREASE) is specified more than once.
Action: Specify all storage options at most once.
ORA-02218: invalid INITIAL storage option value
Cause: The specified value must be an integer.
Action: Choose an appropriate integer value.
ORA-02219: invalid NEXT storage option value
Cause: The specified value must be an integer.
Action: Choose an appropriate integer value.
ORA-02220: invalid MINEXTENTS storage option value
Cause: The specified value must be a positive integer less than or equal to
MAXEXTENTS.
Action: Specify an appropriate value.
ORA-02221: invalid MAXEXTENTS storage option value
Cause: The specified value must be a positive integer greater than or equal to
MINEXTENTS.
Action: Specify an appropriate value.
ORA-02222: invalid PCTINCREASE storage option value
Cause: The specified value must be a positive integer.
Action: Specify an appropriate value.
ORA-02223: invalid OPTIMAL storage option value
Cause: The specified value must be an integer.
Action: Choose an appropriate integer value.
ORA-02224: EXECUTE privilege not allowed for tables
Cause: An attempt was made to grant or revoke an invalid privilege on a table.
Action: Do not attempt to grant or revoke EXECUTE privilege on tables.
ORA-02225: only EXECUTE and DEBUG privileges are valid for procedures
Cause: An attempt was made to grant or revoke an invalid privilege on a
procedure, function or package.
Action: Do not attempt to grant or revoke any privilege besides EXECUTE or
DEBUG on procedures, functions or packages.
ORA-02226: invalid MAXEXTENTS value (max allowed: string)
Cause: The MAXEXTENTS specified is too large for the database block size. This
applies only to SYSTEM rollback segment.
Action: Specify a smaller value.
ORA-02140 to ORA-04099 5-9
ORA-02227: invalid cluster name
Cause: A cluster name of the form [ <identifier> . ] <identifier> is expected but
not present.
Action: Enter an appropriate cluster name.
ORA-02228: duplicate SIZE specification
Cause: The SIZE option is specified more than once.
Action: Specify the SIZE option at most once.
ORA-02229: invalid SIZE option value
Cause: The specified value must be an integer number of bytes.
Action: Specify an appropriate value.
ORA-02230: invalid ALTER CLUSTER option
Cause: An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS,
STORAGE, or SIZE is specified in an ALTER CLUSTER statement.
Action: Specify only legal options.
ORA-02231: missing or invalid option to ALTER DATABASE
Cause: An option other than ADD, DROP, RENAME, ARCHIVELOG,
NOARCHIVELOG, MOUNT, DISMOUNT, OPEN, or CLOSE is specified in the
statement.
Action: Specify only legal options.
ORA-02232: invalid MOUNT mode
Cause: A mode other than SHARED or EXCLUSIVE follows the MOUNT
keyword in an ALTER DATABASE statement.
Action: Specify either SHARED, EXCLUSIVE, or nothing following MOUNT.
ORA-02233: invalid CLOSE mode
Cause: A mode other than NORMAL or IMMEDIATE follows the CLOSE
keyword in an ALTER DATABASE statement.
Action: Specify either NORMAL, IMMEDIATE, or nothing following CLOSE.
ORA-02234: changes to this table are already logged
Cause: the log table to be added is a duplicate of another
Action: Don't add this change log to the system; check that the replication
product's system tables are consistent
ORA-02235: this table logs changes to another table already
Cause: the table to be altered is already a change log for another table
Action: Don't log changes to the specified base table to this table; check that the
replication product's system tables are consistent
ORA-02236: invalid file name
Cause: A character string literal was not used in the filename list of a LOGFILE,
DATAFILE, or RENAME clause.
Action: Use correct syntax.
ORA-02237: invalid file size
Cause: A non-integer value was specified in the SIZE or RESIZE clause.
5-10 Oracle Databas
ORA-02140: invalid tablespace name
Cause: An identifier does not follow ALTER TABLESPACE.
Action: Specify a tablespace name following ALTER TABLESPACE.
ORA-02141: invalid OFFLINE option
Cause: An option other than NORMAL or IMMEDIATE follows OFFLINE.
Action: The user must either specify no option following OFFLINE or one of the
options NORMAL or IMMEDIATE.
ORA-02142: missing or invalid ALTER TABLESPACE option
Cause: A valid option was not present.
Action: Use one of the valid options: add, rename, default, online, offline, read
only, read write, begin, end, no, force, retention guarantee and retention
noguarantee.
ORA-02143: invalid STORAGE option
Cause: An option other than INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, or
PCTINCREASE was specified in the STORAGE clause.
Action: Specify only valid options.
ORA-02144: no option specified for ALTER CLUSTER
Cause: No ALTER CLUSTER options are specified.
Action: Specify one or more of the following options: pctfree, pctused, size,
storage.
ORA-02145: missing STORAGE option
Cause: No STORAGE options were specified following STORAGE (
Action: Specify one or more STORAGE option between the parentheses.
ORA-02146: SHARED specified multiple times
Cause: The SHARED option was specified in a CREATE DATABASE statement
multiple times.
Action: Only specify the SHARED option once.
ORA-02147: conflicting SHARED/EXCLUSIVE options
Cause: Both the SHARED and EXCLUSIVE options were specified in a CREATE
DATABASE statement.
Action: Specify SHARED or EXCLUSIVE, but not both.
5-2 Oracle Database Error Messages
ORA-02148: EXCLUSIVE specified multiple times
Cause: The EXCLUSIVE option was specified in a CREATE DATABASE statement
multiple times.
Action: Only specify the EXCLUSIVE option once.
ORA-02149: Specified partition does not exist
Cause: Partition not found for the object.
Action: Retry with correct partition name.
ORA-02150: invalid new tablespace name
Cause: The new tablespace name specified in ALTER TABLESPACE RENAME TO
statement was invalid.
Action: Retry with a valid new tablespace name.
ORA-02151: invalid tablespace name: string
Cause: Oracle cannot create a tablespace whose name starts with '_$deleted$'.
Action: Try a different tablespace name.
ORA-02152: Invalid ALTER TABLESPACE ... RENAME option
Cause: An option other than DATAFILE or TO follows by ALTER TABLESPACE
... RENAME.
Action: The user must specify either DATAFILE or TO following ALTER
TABLESPACE ... RENAME.
ORA-02153: invalid VALUES password string
Cause: An encoded password string does not follow the VALUES clause.
Action: Place a proper encoded password string after the VALUES clause.
ORA-02154: a tablespace with the name 'string' is found
Cause: An attempt to rename a tablespace to a new name failed because the new
name is already used by some other tablespace.
Action: Retry with a different new name.
ORA-02155: invalid DEFAULT tablespace identifier
Cause: An identifier does not follow DEFAULT TABLESPACE.
Action: Place a tablespace name after DEFAULT TABLESPACE.
ORA-02156: invalid TEMPORARY tablespace identifier
Cause: An identifier does not follow TEMPORARY TABLESPACE.
Action: Place a tablespace name after TEMPORARY TABLESPACE.
ORA-02157: no options specified for ALTER USER
Cause: No options were specified.
Action: Specify at least one ALTER USER option.
ORA-02158: invalid CREATE INDEX option
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.
ORA-02140 to ORA-04099 5-3
ORA-02159: installed DLM does not support releasable locking mode
Cause: The parameter file specified gc_* parameters that allow locks to be release
by the LCK process when not in use. This mode requires additional support from
the DLM that is not available.
Action: Specify configuration parameters that do not require the additional
function.
ORA-02160: index-organized table can not contain columns of type LONG
Cause: A column of type LONG defined for index-organized table.
Action: Do not use columns of type LONG in index-organized tables.
ORA-02161: invalid value for MAXLOGFILES
Cause: A number does not follow MAXLOGFILES.
Action: Specify a number after MAXLOGFILES.
ORA-02162: invalid value for MAXDATAFILES
Cause: A number does not follow MAXDATAFILES.
Action: Specify a number after MAXDATAFILES.
ORA-02163: invalid value for FREELIST GROUPS
Cause: A number does not follow FREELIST GROUPS.
Action: Specify a number after FREELIST GROUPS.
ORA-02164: DATAFILE clause specified more than once
Cause: The CREATE DATABASE command contains more than one DATAFILE
clause.
Action: Specify at most one DATAFILE clause.
ORA-02165: invalid option for CREATE DATABASE
Cause: An invalid CREATE DATABASE option is present.
Action: Specify only valid CREATE DATABASE options.
ORA-02166: ARCHIVELOG and NOARCHIVELOG specified
Cause: Both ARCHIVELOG and NOARCHIVELOG are specified in a CREATE
DATABASE statement.
Action: Specify at most one of these two options.
ORA-02167: LOGFILE clause specified more than once
Cause: The CREATE DATABASE command contains more than one LOGFILE
clause.
Action: Specify at most one LOGFILE clause.
ORA-02168: invalid value for FREELISTS
Cause: A number does not follow FREELISTS
Action: Specify a number after FREELISTS
ORA-02169: FREELISTS storage option not allowed
Cause: The user attempted to specify the FREELISTS storage option. This option
may only be specified during create table or create index.
Action: Remove these options and retry the statement.
ORA-02170: FREELIST GROUPS storage option not allowed
5-4 Oracle Database Error Messages
Cause: The user attempted to specify the FREELIST GROUPS storage option. This
option may only be specified during create table and when allow_freelist_groups
INIT.ORA is specified.
Action: Remove this option and retry the statement or set the allow_freelist_
groups INIT.ORA parameter.
ORA-02171: invalid value for MAXLOGHISTORY
Cause: A number does not follow MAXLOGHISTORY
Action: Specify a number after MAXLOGHISTORY
ORA-02172: The PUBLIC keyword is not appropriate for a disable thread
Cause: The PUBLIC keyword was specified for a disable.
Action: Remove the keyword and resubmit.
ORA-02173: invalid option for DROP TABLESPACE
Cause: Either a token other than INCLUDING was found following the
tablespace name or some text was found following INCLUDING CONTENTS.
Action: Place nothing or only INCLUDING CONTENTS after the tablespace
name.
ORA-02174: Missing required thread number
Cause: Must specify thread number after THREAD keyword
Action: None
ORA-02175: invalid rollback segment name
Cause: In the CREATE or DROP ROLLBACK SEGMENT statements, an identifier
was not found following ROLLBACK SEGMENT.
Action: Place the segment name following ROLLBACK SEGMENT.
ORA-02176: invalid option for CREATE ROLLBACK SEGMENT
Cause: An invalid option was specified in a CREATE ROLLBACK SEGMENT
statement.
Action: Specify one of the valid options: TABLESPACE and STORAGE.
ORA-02177: Missing required group number
Cause: Must specify group number after GROUP keyword
Action: None
ORA-02178: correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
Cause: There is a syntax error in the user's statement.
Action: Correct the syntax as indicated.
ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ
COMMITTED }
Cause: There is a syntax error in the user's statement.
Action: Correct the syntax as indicated.
ORA-02180: invalid option for CREATE TABLESPACE
Cause: An invalid option appeared.
Action: Specify one of the valid options: DATAFILE, DEFAULT STORAGE,
ONLINE, OFFLINE, FORCE, RETENTION.
ORA-02140 to ORA-04099 5-5
ORA-02181: invalid option to ROLLBACK WORK
Cause: A token other than TO follows ROLLBACK [WORK].
Action: Place nothing or TO SAVEPOINT <name> after ROLLBACK [WORK].
ORA-02182: savepoint name expected
Cause: An identifier does not follow ROLLBACK [WORK] TO [SAVEPOINT].
Action: Place a savepoint name following TO [SAVEPOINT].
ORA-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE | READ
COMMITTED }
Cause: There is a syntax error in the user's statement.
Action: Correct the syntax as indicated.
ORA-02184: resource quotas are not allowed in REVOKE
Cause: In a revoke statement, a resource quota was specified.
Action: Specify resource privilege without the quota.
ORA-02185: a token other than WORK follows COMMIT
Cause: A token other than WORK follows COMMIT.
Action: Place either nothing or WORK after COMMIT.
ORA-02186: tablespace resource privilege may not appear with other privileges
Cause: An attempt was made to grant or revoke a resource quota in the same
statement in which other privileges are granted or revoked.
Action: Use a separate grant or revoke statement for the resource quota privilege.
ORA-02187: invalid quota specification
Cause: In a grant or revoke statement, the user attempted to grant a tablespace
quota above the upper limit.
Action: Grant a smaller tablespace quota.
ORA-02188: Cannot enable instance publicly
Cause: An attempt was made to publicly enable a thread associated with an
instance.
Action: Leave out the PUBLIC keyword.
ORA-02189: ON <tablespace> required
Cause: In a grant or revoke statement, the user specified a tablespace quota but
did not follow it with the ON <tablespace> clause.
Action: Specify the tablespace on which the quota is to be applied with the ON
<tablespace> clause.
ORA-02190: keyword TABLES expected
Cause: The keyword TABLES is expected following DROP CLUSTER <name>
INCLUDING.
Action: Place TABLES after INCLUDING.
ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT
<rbs>
Cause: There is a syntax error in the user's statement.
Action: Correct the syntax as indicated.
5-6 Oracle Database Error Messages
ORA-02192: PCTINCREASE not allowed for rollback segment storage clauses
Cause: pctincrease was specified in a create or alter rollback segment
Action: reissue statement without the pctincrease clause
ORA-02194: event specification syntax error string (minor error string) near 'string'
Cause: There is a syntax error in an event specification.
Action: Fix the error.
ORA-02195: Attempt to create string object in a string tablespace
Cause: The object type is inconsistent with a tablespace contents.
Action: Create an object in a different tablespace, or change the user defaults.
ORA-02196: PERMANENT/TEMPORARY option already specified
Cause: In CREATE TABLESPACE, the PERMANENT and/or TEMPORARY
options were specified more than once.
Action: None
ORA-02197: file list already specified
Cause: In CREATE TABLESPACE, more than one DATAFILE/TEMPFILE clause
was specified.
Action: Merge the DATAFILE/TEMPFILE clauses into a single clause.
ORA-02198: ONLINE/OFFLINE option already specified
Cause: In CREATE TABLESPACE, the ONLINE and/or OFFLINE options were
specified more than once.
Action: Specify at most one of ONLINE or OFFLINE.
ORA-02199: missing DATAFILE/TEMPFILE clause
Cause: A CREATE TABLESPACE statement has no DATAFILE/TEMPFILE clause.
Action: Specify a DATAFILE/TEMPFILE clause.
ORA-02200: WITH GRANT OPTION not allowed for PUBLIC
Cause: An attempt was made to GRANT to PUBLIC WITH GRANT OPTION.
Action: Remove the WITH GRANT OPTION clause.
ORA-02201: sequence not allowed here
Cause: An attempt was made to reference a sequence in a from-list.
Action: A sequence can only be referenced in a select-list.
ORA-02202: no more tables permitted in this cluster
Cause: An attempt was made to create a table in a cluster which already contains
32 tables.
Action: Up to 32 tables may be stored per cluster.
ORA-02203: INITIAL storage options not allowed
Cause: The user attempted to alter the INITIAL storage option of a table, cluster,
index, or rollback segment. These options may only be specified when the object is
created.
Action: Remove these options and retry the statement.
ORA-02204: ALTER, INDEX and EXECUTE not allowed for views
ORA-02140 to ORA-04099 5-7
Cause: An attempt was made to grant or revoke an invalid privilege on a view.
Action: Do not attempt to grant or revoke any of ALTER, INDEX, or EXECUTE
privileges on views.
ORA-02205: only SELECT and ALTER privileges are valid for sequences
Cause: An attempt was made to grant or revoke an invalid privilege on a
sequence.
Action: Do not attempt to grant or revoke DELETE, INDEX, INSERT, UPDATE,
REFERENCES or EXECUTE privilege on sequences.
ORA-02206: duplicate INITRANS option specification
Cause: INITRANS is specified more than once.
Action: Specify INITRANS at most once.
ORA-02207: invalid INITRANS option value
Cause: The INITRANS value is not an integer between 1 and 255 and less than or
equal to the MAXTRANS value.
Action: Choose a valid INITRANS value.
ORA-02208: duplicate MAXTRANS option specification
Cause: MAXTRANS is specified more than once.
Action: Specify MAXTRANS at most once.
ORA-02209: invalid MAXTRANS option value
Cause: The MAXTRANS value is not an integer between 1 and 255 and greater
than or equal to the INITRANS value.
Action: Choose a valid MAXTRANS value.
ORA-02210: no options specified for ALTER TABLE
Cause: No ALTER TABLE option was specified.
Action: Specify at least one alter table option.
ORA-02211: invalid value for PCTFREE or PCTUSED
Cause: The specified value for PCTFREE or PCTUSED is not an integer between 0
and 100.
Action: Choose an appropriate value for the option.
ORA-02212: duplicate PCTFREE option specification
Cause: PCTFREE option specified more than once.
Action: Specify PCTFREE at most once.
ORA-02213: duplicate PCTUSED option specification
Cause: PCTUSED option specified more than once.
Action: Specify PCTUSED at most once.
ORA-02214: duplicate BACKUP option specification
Cause: The BACKUP option to ALTER TABLE is specified more than once.
Action: Specify the option at most once.
ORA-02215: duplicate tablespace name clause
Cause: There is more than one TABLESPACE clause in the CREATE TABLE,
CREATE INDEX, or CREATE ROLLBACK SEGMENT statement.
5-8 Oracle Database Error Messages
Action: Specify at most one TABLESPACE clause.
ORA-02216: tablespace name expected
Cause: A tablespace name was not present where required by the syntax for the
failing statement.
Action: Specify a tablespace name where required by the syntax.
ORA-02217: duplicate storage option specification
Cause: A storage option (INIITAL, NEXT, MINEXTENTS, MAXEXTENTS,
PCTINCREASE) is specified more than once.
Action: Specify all storage options at most once.
ORA-02218: invalid INITIAL storage option value
Cause: The specified value must be an integer.
Action: Choose an appropriate integer value.
ORA-02219: invalid NEXT storage option value
Cause: The specified value must be an integer.
Action: Choose an appropriate integer value.
ORA-02220: invalid MINEXTENTS storage option value
Cause: The specified value must be a positive integer less than or equal to
MAXEXTENTS.
Action: Specify an appropriate value.
ORA-02221: invalid MAXEXTENTS storage option value
Cause: The specified value must be a positive integer greater than or equal to
MINEXTENTS.
Action: Specify an appropriate value.
ORA-02222: invalid PCTINCREASE storage option value
Cause: The specified value must be a positive integer.
Action: Specify an appropriate value.
ORA-02223: invalid OPTIMAL storage option value
Cause: The specified value must be an integer.
Action: Choose an appropriate integer value.
ORA-02224: EXECUTE privilege not allowed for tables
Cause: An attempt was made to grant or revoke an invalid privilege on a table.
Action: Do not attempt to grant or revoke EXECUTE privilege on tables.
ORA-02225: only EXECUTE and DEBUG privileges are valid for procedures
Cause: An attempt was made to grant or revoke an invalid privilege on a
procedure, function or package.
Action: Do not attempt to grant or revoke any privilege besides EXECUTE or
DEBUG on procedures, functions or packages.
ORA-02226: invalid MAXEXTENTS value (max allowed: string)
Cause: The MAXEXTENTS specified is too large for the database block size. This
applies only to SYSTEM rollback segment.
Action: Specify a smaller value.
ORA-02140 to ORA-04099 5-9
ORA-02227: invalid cluster name
Cause: A cluster name of the form [ <identifier> . ] <identifier> is expected but
not present.
Action: Enter an appropriate cluster name.
ORA-02228: duplicate SIZE specification
Cause: The SIZE option is specified more than once.
Action: Specify the SIZE option at most once.
ORA-02229: invalid SIZE option value
Cause: The specified value must be an integer number of bytes.
Action: Specify an appropriate value.
ORA-02230: invalid ALTER CLUSTER option
Cause: An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS,
STORAGE, or SIZE is specified in an ALTER CLUSTER statement.
Action: Specify only legal options.
ORA-02231: missing or invalid option to ALTER DATABASE
Cause: An option other than ADD, DROP, RENAME, ARCHIVELOG,
NOARCHIVELOG, MOUNT, DISMOUNT, OPEN, or CLOSE is specified in the
statement.
Action: Specify only legal options.
ORA-02232: invalid MOUNT mode
Cause: A mode other than SHARED or EXCLUSIVE follows the MOUNT
keyword in an ALTER DATABASE statement.
Action: Specify either SHARED, EXCLUSIVE, or nothing following MOUNT.
ORA-02233: invalid CLOSE mode
Cause: A mode other than NORMAL or IMMEDIATE follows the CLOSE
keyword in an ALTER DATABASE statement.
Action: Specify either NORMAL, IMMEDIATE, or nothing following CLOSE.
ORA-02234: changes to this table are already logged
Cause: the log table to be added is a duplicate of another
Action: Don't add this change log to the system; check that the replication
product's system tables are consistent
ORA-02235: this table logs changes to another table already
Cause: the table to be altered is already a change log for another table
Action: Don't log changes to the specified base table to this table; check that the
replication product's system tables are consistent
ORA-02236: invalid file name
Cause: A character string literal was not used in the filename list of a LOGFILE,
DATAFILE, or RENAME clause.
Action: Use correct syntax.
ORA-02237: invalid file size
Cause: A non-integer value was specified in the SIZE or RESIZE clause.
5-10 Oracle Databas
最低0.47元/天 解锁文章
5498
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
