[ Pobierz całość w formacie PDF ]
.Action Remote updates can be performed only if all databases in the SQL statementare Oracle7 Servers.Update the earlier version databases in aseparate statement.ORA 02026 missing LINK keywordCause The keyword LINK is required in this context.Action Check syntax, insert keyword LINK as required, and try again.ORA 02027 multi row UPDATE of LONG column is not supportedCause A bind variable whose length is greater than 2000 bytes is being used to updatea column, and the UPDATE statement affects more than one row.Action Check that each such bind variable updates only a single row.ORA 02028 fetching an exact number of rows is not supported by the serverCause The server does not support UPIALL, so the fetch of an exact number of rowscannot be emulated on the user side.Action Connect to a valid server or do not use an exact fetch.ORA 02029 missing FILE keywordCause The keyword FILE is required in this context.Action Check syntax, insert keyword FILE as required, and try again.ORA 02030 can only select from fixed tables/viewsCause An operation other than SELECT on a fixed dynamic performance table orview was attempted.It is only possible to select from fixed tables or views.Action Remove the fixed table or view name from the SELECT statement.ORA 02031 no ROWID for fixed tablesCause An attempt was made to select the ROWID from a fixed table.Action Do not select ROWID from a fixed table.2  200 Oracle7 Server Messages01900 02039: SQL ParsingORA 02032 clustered tables cannot be used before the cluster index is builtCause An attempt was made to perform a DML operation on a clustered table forwhich no cluster index has yet been created.Action Create a cluster index before referencing clustered tables in a SQL statement.ORA 02033 a cluster index for this cluster already existsCause A cluster index already exists for the cluster.Action No action required.ORA 02034 speed bind not permittedCause Speed bind not allowed with supplied bind variables.Action No action required.ORA 02035 illegal bundled operation combinationCause UPI bundled execution call was requested on an illegal combinationof operations.Action Use a legal combination of operations and retry.ORA 02036 too many variables to describe with automatic cursor openCause UPI bundled execution call tried to perform automatic cursor open and closeon a describe operation.There were too many SELECT list items or bindvariables to do this.Action Open and close cursor explicitly.ORA 02037 universalized speed bind storageCause A user attempted to perform a speed execution call on a SQL statementcontaining host variables without first performing a speed bind call.Action Perform a speed bind call before performing a speed execution call.ORA 02038 define is not allowed for array typeCause A user attempted to define a select list variable of type  array.Arrays mayserve only as host bind variables.Action Correct the offending code.Oracle7 Server Messages 2  20101900 02039: SQL ParsingORA 02039 bind by value is not allowed for array typeCause User attempted to bind an array host variable by value.Arrays may be boundonly by reference.Action Correct the offending code.2  202 Oracle7 Server Messages02040 02099: Distributed Transactions02040 02099: Distributed TransactionsThis section lists messages generated during distributed transactions.ORA 02040 remote database name does not support two phase commitCause A distributed update of more than one database was attempted, but the nameddatabase does not support the prepare phase of the two phase commit, asdetermined by its logon transaction traits.The transaction was rolled back.Action Do not attempt to update the named database, unless it is the only databaseupdated in the transaction.Distributed updates of more than one database in asingle transaction can be performed only if all databases support the two phasecommit mechanism.ORA 02041 client database did not begin a transactionCause An update occurred at a coordinated database without the coordinatorbeginning a distributed transaction.This may happen if a stored procedurecommits and then performs updates, and the stored procedure is invokedremotely.It could also happen if an external transaction monitor violates theXA protocol.Action If the cause is the former, check that any commit is not followed by an update.ORA 02042 too many distributed transactionsCause The distributed transaction table is full because too many distributedtransactions are active.Action Increase the DISTRIBUTED_TRANSACTIONS parameter in the initializationparameter file, shut down and restart Oracle, or run fewer transactions.If it iscertain there are not too many concurrent distributed transactions, this may bean internal error.In this case, contact customer support.Shutting down andrestarting the instance could be a work around.ORA 02043 must end current transaction before executing commandCause A transaction is in progress and one of the following commands is issued:COMMIT FORCE, ROLLBACK FORCE, or ALTER SYSTEM ENABLEDISTRIBUTED RECOVERY in single process mode.Action COMMIT or ROLLBACK the current transaction and retry the command.Oracle7 Server Messages 2  20302040 02099: Distributed TransactionsORA 02044 transaction manager login denied: transaction in progressCause A remote transaction manager tried to log in while a distributed transaction isin progress.A protocol error occurred in the remote transaction manager.Action End the current transaction.ORA 02045 too many local sessions participating in global transactionsCause There are too many sessions at this site to accommodate this transaction.Action Use an existing database link so that another session need not be created at theremote site.ORA 02046 distributed transaction already begunCause This is an internal error not normally encountered.A server session received aBEGIN_TRAN remote procedure call before finishing with a previousdistributed transaction.Action Contact customer support.ORA 02047 cannot join the distributed transaction in progressCause This can happen only when attempting to update an Oracle Version 6 and anOracle7 database in the same transaction, because either" A transaction is in progress against a remote database that does notsupport two phase commit." Updates are pending and an attempt was made to update a differentdatabase that does not support two phase commit.Action Complete the current transaction before attempting the action that causedthe error.ORA 02048 attempt to begin distributed transaction without logging onCause The client program did not issue a distributed transaction login.Action This is an internal error, contact customer support.2  204 Oracle7 Server Messages02040 02099: Distributed TransactionsORA 02049 time out: distributed transaction waiting for lockCause The time to wait on a lock in a distributed transaction has been exceeded.Thistime is specified in the initialization parameterDISTRIBUTED_LOCK_TIMEOUT.Action This situation is treated as a deadlock and the statement was rolled back.To setthe time out interval to a longer interval, adjust the initialization parameterDISTRIBUTED_LOCK_TIMEOUT, then shut down and restart the instance [ Pobierz całość w formacie PDF ]