我的表是个分区表,有一万个分区,现在将BUFFER加大了,可还出现以下错误:
IMP-00003: ORACLE error 52 encountered
ORA-00052: maximum number of enqueue resources (1692) exceeded
Import terminated successfully with warnings.
咋办呢?
ORA-00052 maximum number of enqueue resources (string) exceeded
Cause: Ran out of enqueue resources.
Action: Increase the value of the ENQUEUE_RESOURCES initialization parameter.
你试试，是开发库吧？
SQL> show parameter ENQUEUE_RESOURCES;
NAME
TYPEVALUE
------------------------------------ ------- ------------------------------
enqueue_resources
integer 1308
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE8.1.7.2.1 Production
TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
应该有的啊，不行你手工加一条。
