If the transaction aborted at a remote site, only ORA–02091 will be seen. If the transaction aborted at the host site, then both ORA–02091 and ORA–02092 will be seen.
Action
Complete the current transaction and then do the operation required.
ORA–02092
out of transaction table slots for distributed transaction
Cause
The distributed transaction is assigned to the system rollback segment and is trying to get into the prepared state, but the required number of
non–PREPARED slots are not available, so the transaction is rolled back.
If the transaction aborted at a remote site, only ORA–02091 will be seen. If the transaction aborted at the host site, then both ORA–2091 and ORA–2092 will be seen.
Cause
Add a rollback segment and do the operation again.
Oracle7 Server Messages
2 – 211
02100–02139: Precompiler Runtime SQLLIB
ORA–02093
TRANSACTIONS_PER_ROLLBACK_SEGMENT name more than maximum possible.
Cause
The value of the initialization parameter specified is greater than allowed on this port.
Action
Use the default value or reduce it to less than the maximum.
ORA–02094
replication option not installed
Cause
The replication option was not installed at this site. Updatable snapshots, deferred remote procedure calls, and other replication features were, therefore, unavailable.
Action
Install the replication option. The replication option is not part of the Oracle7
Server product and must be purchased separately. Contact an Oracle sales representative if the replication option needs to be purchased.
02100–02139: Precompiler Runtime SQLLIB
The messages in this range have the same cause and action as listed in Chapter 4. For example, ORA–2100 is the same as SQL–2100.
02140–02299: SQL Parsing
This section lists some of the messages generated when SQL statements are parsed by the Oracle Server.
ORA–02140
invalid tablespace name
Cause
A valid tablespace name does not follow ALTER TABLESPACE.
Action
Specify a valid tablespace name following ALTER TABLESPACE.
ORA–02141
invalid OFFLINE option
Cause
An option other than NORMAL or IMMEDIATE follows OFFLINE in an
ALTER TABLESPACE statement.
Action
The user must either specify no option following OFFLINE or one of these options: NORMAL or IMMEDIATE.
2 – 212
Oracle7 Server Messages
02140–02299: SQL Parsing
ORA–02142
missing or invalid ALTER TABLESPACE option
Cause
An invalid option was specified after ALTER TABLESPACE.
Action
Use one of the valid options, such as ADD DATAFILE, RENAME DATAFILE, DEFAULT STORAGE, ONLINE, OFFLINE, BEGIN BACKUP, or
END BACKUP.
ORA–02143
invalid STORAGE option
Cause
An option other than INITIAL, NEXT, MINEXTENTS, MAXEXTENTS,
FREELISTS, FREELIST GROUPS, or PCTINCREASE was specified in an
ALTER INDEX statement or in the USING INDEX clause of an ALTER
SNAPSHOT statement.
Action
Check syntax, specify only valid options, and try again.
ORA–02144
no option specified for ALTER CLUSTER
Cause
No valid ALTER CLUSTER options were specified.
Action
Specify one or more valid options, such as PCTFREE, PCTUSED, SIZE, INITRANS, MAXTRANS, or STORAGE.
ORA–02145
missing STORAGE option
Cause
No STORAGE options were specified following the keyword STORAGE.
Action
Check syntax, specify one or more valid STORAGE options, and try again.
ORA–02146
SHARED specified multiple times
Cause
The SHARED option was specified more than once in a CREATE
DATABASE statement.
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.
Oracle7 Server Messages
2 – 213
02140–02299: SQL Parsing
ORA–02148
EXCLUSIVE specified multiple times
Cause
The EXCLUSIVE option was specified in a CREATE DATABASE statement
more than once.
Action
Only specify the EXCLUSIVE option once.
ORA–02155
invalid DEFAULT tablespace identifier
Cause
A valid tablespace name does not follow DEFAULT TABLESPACE.
Action
Place a valid tablespace name after DEFAULT TABLESPACE and try again.
ORA–02156