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>


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.jp
Received on Mon Jan 30 1995 - 08:16:32 CET

Original text of this message