ORA-57: What error?
From: Youichi Tamura <y-tamura_at_nriws11.nri.co.jp>
Date: Mon, 30 Jan 1995 07:16:32 GMT
Message-ID: <D37IvM.6BG_at_nrigw11.nri.co.jp>
Date: Mon, 30 Jan 1995 07:16:32 GMT
Message-ID: <D37IvM.6BG_at_nrigw11.nri.co.jp>
I'm currently connected to
Oracle7 Server Release 7.1.3.4.0 - Production Release
With the distributed option PL/SQL Release 2.1.3.2.0 - Production
My question is: Does the error ORA-57 have a different meaning in Version 7.1.3. than in Version 7.0 ?
oerr gives me the following:
% oerr ora 57 00057, 00000, "maximum number of temporary table locks exceeded" // *Cause: The number of temporary tables equals or exceeds the number of
// temporary table locks. Temporary tables are often created by
// large sorts.
// *Action: Increase the "temporary_table_locks" init.ora parameter and
// warm start.
Yet the error message I received along with code 57 indicates that I need more shared pool areas. Is this a simple bug in error handling, or does the error code have different meanings in different ORACLE versions?
(I shall omit the details of the situation in which this error occurs since that is not the subject of this post.)
Code reference manuals are not much help here.
-- Yoichi Tamura y-tamura_at_nri.co.jpReceived on Mon Jan 30 1995 - 08:16:32 CET