ORA-20005: object statistics are locked (stattype = ALL)

最新推荐文章于 2024-10-25 16:00:00 发布
最新推荐文章于 2024-10-25 16:00:00 发布
阅读量3.6k 收藏 3
点赞数
CC 4.0 BY-SA版权
分类专栏： Oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/mikean/article/details/11541821
本文详细阐述了在使用Oracle数据库迁移工具时，遇到ObjectStatisticsLocked错误的解决方案，包括导出、导入表结构与数据的具体步骤，以及如何避免和解决此问题的策略。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

今天从9i中exp后imp 至10g中，因为要修改栏位长度，所以先imp 加参数rows=n ； 再imp资料 ignore=y

报错 ORA-20005: OBJECT STATISTICS ARE LOCKED (STATTYPE = ALL)。

从DBA_TAB_STATISTICS中发现统计视图中STATTYPE=ALL了，默认情况中该字段为null，表示没有锁住信息。

运行DBMS_STATS.UNLOCK_TABLE_STATS来解锁表统计信息，就可以对表进行分析了。

注意在imp结构的时候要加上 statistics=none,默认值是always

imp资料时候要加上statistics=safe 当原数据exp的统计信息和真实的统计信息一致的时候，imp源统计信息；
                                当原数据exp的统计信息和真实的统计信息不一致的时候，重新计算优化器统计信息


To avoid the ORA-20005:
- Unlock the table statistics after the import:
  execute DBMS_STATS.UNLOCK_TABLE_STATS('<user name>','<table name>');
OR
-Do not import the table statistics(EXCLUDE=TABLE_STATISTICS impdp parameter)


SQL> exec dbms_stats.unlock_table_stats(ownname => 'ECC_VIEW',tabname => 'TABLE_TEST1'); 
PL/SQL procedure successfully completed 
or
SQL> EXEC DBMS_STATS.unlock_schema_stats(ownname => 'ECC_VIEW');
PL/SQL procedure successfully completed

SQL> exec dbms_stats.gather_table_stats(ownname => 'ECC_VIEW',tabname => 'TABLE_TEST1',cascade => TRUE,estimate_percent => 20); 
PL/SQL procedure successfully completed


______________________________________________________________________________________________________________________________

以下是网上收集到的一个案例，转载一下。


在做10.2.0.4数据库服务器上IMP的时候，由于特殊原因，需要先导入dmp1的表结构，然后在imp dmp2的数据，所以在imp的时候遇到一个问题：
    ORA-20005: object statistics are locked (stattype = ALL)
    操作步骤如下：
1. 导出ecc_view用户，生成ecc_view.dmp文件
[oracle@rac1 ~]$ echo $NLS_LANG
american_america.ZHS16GBK
[oracle@rac1 ~]$expecc_view/ecc@devdb1file=./ecc_view.dmp
Export: Release 10.2.0.4.0 - Production on Wed Jun 24 09:42:04 2009
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
。。。。
. about to export ECC_VIEW's tables via Conventional Path ...
. . exporting table                      ECC_VIEW1         23 rows exported
. . exporting table                              T     100000 rows exported
. . exporting table                         TABLE1          0 rows exported
. . exporting table                           TEST          4 rows exported
. exporting synonyms
. exporting views
。。。。
Export terminated successfully without warnings.
2. 创建用户ecc_view3
 
   create user ecc_view3
   identified by ecc
   default tablespace DATA03

   grant connect, resource to ecc_view3


3. 只导表结构
[oracle@rac1 ~]$impecc_view3/ecc@devdb1file=./ecc_view.dmp rows=n FROMUSER=ECC_VIEWTOUSER=ECC_VIEW3
Import: Release 10.2.0.4.0 - Production on Wed Jun 24 09:46:31 2009
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by ECC_VIEW, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Import terminated successfully without warnings.

4. 导入数据
a.  statistics = always(default)
   (Always imports database optimizer statistics regardless of whether or not they are questionable)
   备注：无论统计信息是否有疑问，即是否为最新的，总是导入resource数据库中对象的统计信息

[oracle@rac1 ~]$impecc_view3/ecc@devdb1file=./ecc_view.dmp ignore=y FROMUSER=ECC_VIEWTOUSER=ECC_VIEW3
Import: Release 10.2.0.4.0 - Production on Wed Jun 24 09:48:02 2009
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by ECC_VIEW, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. . importing table                    "ECC_VIEW1"         23 rows imported
IMP-00017: following statement failed with ORACLE error 20005:
 "BEGIN  DBMS_STATS.SET_INDEX_STATS(NULL,'"INX_CREATEDATE"',NULL,NULL,NULL,23"
 ",1,23,1,1,1,0,6); END;"
IMP-00003: ORACLE error 20005 encountered
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 1610
ORA-06512: at "SYS.DBMS_STATS", line 2120
ORA-06512: at "SYS.DBMS_STATS", line 5473
ORA-06512: at line 1
IMP-00017: following statement failed with ORACLE error 20005:
 "BEGIN  DBMS_STATS.SET_TABLE_STATS(NULL,'"ECC_VIEW1"',NULL,NULL,NULL,23,4,10"
 "0,6); END;"
IMP-00003: ORACLE error 20005 encountered
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 1610
ORA-06512: at "SYS.DBMS_STATS", line 2120
ORA-06512: at "SYS.DBMS_STATS", line 6055
ORA-06512: at line 1
Import terminated successfully with warnings.

重建用户
b. statistics = none
 (Does not import or recalculate the database optimizer statistics. )
  不导入或者重新计算数据库中对象的统计信息

[oracle@rac1 ~]$impecc_view3/ecc@devdb1file=./ecc_view.dmp ignore=y FROMUSER=ECC_VIEWTOUSER=ECC_VIEW3statistics=none
Import: Release 10.2.0.4.0 - Production on Wed Jun 24 09:51:50 2009
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by ECC_VIEW, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. . importing table                    "ECC_VIEW1"         23 rows imported
. . importing table                            "T"     100000 rows imported
. . importing table                       "TABLE1"          0 rows imported
. . importing table                         "TEST"          4 rows imported
Import terminated successfully without warnings.

此时不会报错，原因为imp时，不导入或者重新计算数据库中对象的统计信息，所以不会发生object statistics are locked的情况，但是此时的对象统计信息来源于rows=n导入时的记录，为resource database objects的统计信息。

下面两个实验的结果和第一个statistics=always的结果是一致的,因为他们都会重新计算对象的统计信息，所以会发生object statistics are locked的情况。
c.statistics=SAFE
  (Imports database optimizer statistics back only if they are not questionable.                    
   If they are questionable, recalculates the optimizer statistics. )
   备注：当原数据exp的统计信息和真实的统计信息一致的时候，imp源统计信息；
         当原数据exp的统计信息和真实的统计信息不一致的时候，重新计算优化器统计信息
[oracle@rac1 ~]$impecc_view3/ecc@devdb1file=./ecc_view.dmp ignore=y FROMUSER=ECC_VIEW TOUSER=ECC_VIEW3statistics=SAFE;
. . importing table                            "T"     100000 rows imported
. . importing table                       "TABLE1"          0 rows imported
. . importing table                         "TEST"          4 rows imported
IMP-00017: following statement failed with ORACLE error 38029:
 "ANALYZE  TABLE "ECC_VIEW1"  ESTIMATE STATISTICS "
IMP-00003: ORACLE error 38029 encountered
ORA-38029: object statistics are locked
IMP-00017: following statement failed with ORACLE error 38029:
 "ANALYZE  TABLE "T"  ESTIMATE STATISTICS "
IMP-00003: ORACLE error 38029 encountered
ORA-38029: object statistics are locked
Import terminated successfully with warnings.

d.statistics=RECALCULATE
 (Does not import the database optimizer statistics. Instead,recalculates them on import.  )
 不导入源数据库优化统计信息，imp时重新计算统计信息
[oracle@rac1 ~]$impecc_view3/ecc@devdb1file=./ecc_view.dmp ignore=y FROMUSER=ECC_VIEW TOUSER=ECC_VIEW3statistics=RECALCULATE
 . . importing table                            "T"     100000 rows imported
. . importing table                       "TABLE1"          0 rows imported
. . importing table                         "TEST"          4 rows imported
IMP-00017: following statement failed with ORACLE error 38029:
 "ANALYZE  TABLE "ECC_VIEW1"  ESTIMATE STATISTICS "
IMP-00003: ORACLE error 38029 encountered
ORA-38029: object statistics are locked
IMP-00017: following statement failed with ORACLE error 38029:
 "ANALYZE  TABLE "T"  ESTIMATE STATISTICS "
IMP-00003: ORACLE error 38029 encountered
ORA-38029: object statistics are locked
IMP-00017: following statement failed with ORACLE error 38029:
 "ANALYZE  TABLE "TABLE1"  ESTIMATE STATISTICS "
IMP-00003: ORACLE error 38029 encountered
ORA-38029: object statistics are locked
IMP-00017: following statement failed with ORACLE error 38029:
 "ANALYZE  TABLE "TEST"  ESTIMATE STATISTICS "
IMP-00003: ORACLE error 38029 encountered
ORA-38029: object statistics are locked
Import terminated successfully with warnings.

这个是在rows=n的时候选择默认值statistics = always时造成的问题，
我们可以选择在第一次只导入表结构的时候不导入统计信息，然后在导入完重新收集统计信息。
重新开始试验部分
a. imp表结构，并且不导入对象的统计信息
[oracle@rac1 ~]$impecc_view3/ecc@devdb1file=./ecc_view.dmp rows=n FROMUSER=ECC_VIEW TOUSER=ECC_VIEW3statistics=none
Import: Release 10.2.0.4.0 - Production on Wed Jun 24 10:26:22 2009
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by ECC_VIEW, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Import terminated successfully without warnings.

b. imp数据，并且重新计算对象的统计信息
[oracle@rac1 ~]$impecc_view3/ecc@devdb1file=./ecc_view.dmp ignore=y FROMUSER=ECC_VIEW TOUSER=ECC_VIEW3statistics=SAFE;
Import: Release 10.2.0.4.0 - Production on Wed Jun 24 10:27:51 2009
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by ECC_VIEW, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. . importing table                    "ECC_VIEW1"         23 rows imported
. . importing table                            "T"     100000 rows imported
. . importing table                       "TABLE1"          0 rows imported
. . importing table                         "TEST"          4 rows imported
Import terminated successfully without warnings.
 检查统计信息
 select  table_name, tablespace_name, status, num_rows, blocks,last_analyzed
 from user_tables
 table_name   tablespace_name      status   num_rows  blocks  last_analyzed
 ----------------   ---------------------------  ----------      ------------   --------  --------------------
ECC_VIEW1                        USERS        VALID                 23       5    2009-6-24 10:27:55
                     T                       USERS         VALID        100000    250    2009-6-24 10:27:55
         TABLE1                       DATA01        VALID                   0    0    2009-6-24 10:27:55
             TEST                        USERS        VALID                   4    5    2009-6-24 10:27:55

相关资料 from metalink
Symptoms
---------
Either of the following two error messages are signaled:
1. ORA-38029: object statistics are locked
2. ORA-20005: object statistics are locked (stattype = ALL)

Cause
---------
Possible Cause 1:
DBMS_STATS.LOCK_[SCHEMA|TABLE]_STATS has been used to lock statistics on the table.

Possible Cause 2:
Using import (imp) or data pump import (impdp) to import a table without data results in the table's statistics being locked in 10gR2.

Possible Cause 3: （这是我们遇到的情况）
After an IMPORT is finished for which ROWS=N, the statistics for all tables imported will be locked.
Part Number B14233-04 Database Readme 10g Release 2 (10.2) (39.5 Original Export/Import)

Possible Cause 4: If the table is a queue table then the statistics are intended to be empty and locked so that dynamic sampling will be used due to the table's volatility. During an upgrade to 10gR2 statistics on queue tables are deleted and then locked. In 10gR2 when a queue table is created statistics are locked while still empty.

Solution
---------
If the table is a queue table then the statistics should remain empty and locked so that dynamic sampling is used due to the volatility of queue tables. If the table is not a queue table, unlock the statistics using DBMS_STATS.UNLOCK_[SCHEMA|TABLE]_STATS or gather statistics on the table using DBMS_STATS.GATHER_[SCHEMA|TABLE|INDEX]_STATS and the force=>true parameter.

To prevent import (imp) from locking the table's statistics when importing a table without therows (rows=n), use statistics=none. To prevent data pump import (impdp) from locking the table's statistics when importing a table without the rows (content=metadata_only), use exclude=(table_statistics,index_statistics).

有关imp时的参数statistics=always, none, safe, recaculate见链接:
http://blog.youkuaiyun.com/llmmysun/archive/2004/12/09/210805.aspx



ORA-08103报错：expdp提示ORA-08103: object no longer exists，表存在，正常查询，如何解决？
**My Coding Family**
01-22 1277
🏆本文收录于专栏，主要记录项目实战过程中所遇到的Bug或因后果及提供真实有效的解决方案，希望能够助你一臂之力，帮你早日登顶实现财富自由🚀；同时，欢迎大家！持续更新中，up！up！up！！
DATAPUMP导入报ORA-39083和ORA-01917，用户或角色不存在 报错 ORA-39095: 转储文件空间已耗尽: 无法分配 8192 字节
weixin_tank88921的博客
07-30 1452
大概意思就是说oracle的安全机制使得不允许多个写进程同时写一个dump文件，如果此时你的parallel(并发)数值大于（实际导出数据量/fileszie）的数值，那么就会有一些进程闲置，他们只能等待写进程也相当于多个进程在抢占一个进程。在下面的OBJECT_PATH列中，“ROLE” 和 “ROLE_GRANT” 仅出现在 DATABASE_EXPORT 中。2、忽略，也可以手动执行失败的sql，可以执行成功。这个参数默认是Y，如果改成N，那么导入的时候会把各个对象重新赋予新的OID。
oracle20005,oracle 由于impdp 引起的表统计信息被锁 ORA-20005: object statistics are locked...
weixin_42339061的博客
04-09 563
发现一个用户下统计信息没有生成,查询user_tab_modifications 发现变动信息也超过10%没有警告日志执行exec dbms_stats.gather_schema_stats(ownname => 'test',granularity => 'ALL',cascade => true);还是没有生成然后执行报begin dbms_stats.gather_tab...
ora-20005:object statistics are locked(stattype=all)的原因及解决方法
文档搬运工
05-23 4784
RDBMS 11.2.0.4 今天查询发现有个分区表的统计信息一直都没有收集过，通过命令行收集的时候，提示ora-20005:object statistics are locked(stattype=all)，ORA-06512 等错误。 关于这个产生的原因，MOS上有篇文章说的比较详细。MOS上也有其他文章是描述这个错误的（但是只是说怎么解决）。 ORA-38029 "Object St...
ORA-20005：object statistics are locked (stattype = ALL)
cuilun4325的博客
05-30 263
把生产数据库得到一个用户数据导出到另一个数据库里，想收集统计信息的时候提示： ORA-20005：object statistics are locked (stattype = ALL) ...
连接Oracle数据库时报ORA-12541:TNS:无监听程序的图文解决教程
09-10
主要介绍了连接Oracle数据库时报ORA-12541:TNS:无监听程序的图文解决教程,非常不错，具有参考借鉴价值，需要的朋友可以参考下
ORA-39166: Object SYS.AUDIT_LOG was not found.ORA-31655: no data or metadata objects selected for jo
鲨鱼胃的博客
06-03 971
问题描述 将保存审计信息的视图dba_audit_trail转存为表audit_log后导出时报错: [oracle@testrac1 ~]$ expdp \"/ as sysdba\" directory=dmp_dir dumpfile=audit_log.dmp tables= audit_log Export: Release 11.2.0.4.0 - Production on Mon Jun 1 09:13:32 2020 Copyright (c) 1982, 2011, Oracle
ORA-20005: object statistics are locked (stattype = ALL)-转
Rivarola的专栏
10-15 1313
天在做10.2.0.4数据库服务器上IMP的时候，由于特殊原因，需要先导入dmp1的表结构，然后在imp dmp2的数据，所以在imp的时候遇到一个问题：     ORA-20005: object statistics are locked (stattype = ALL)     操作步骤如下： 1. 导出ecc_view用户，生成ecc_view.dmp文件 [oracle@rac1
impdp表统计信息锁ORA-20005: object statistics are locked
kiwixing的博客
10-25 776
impdp加content=metadata_only参数导致表统计信息锁。2.impdp导入dmp文件 content=metadata_only。3.收集统计信息报错被锁ORA 20005。1.expdp导出dmp文件。5.收集统计信息正常。
SAP之ORA-20005: object statistics are locked
Saming study ORACLE
07-23 956
在SAP的数据库优化中，当尝试收集一个数据表的数据时，遇到如下错误：     SQL> exec dbms_stats.gather_table_stats('SAPSR','QIN');     BEGIN dbms_stats.gather_table_stats('SAPSR3','TRFCQIN'); END;     *     ERROR at line 1:    
Oracle数据库性能优化-ora-20005统计信息被锁定
oradbm的博客
07-05 909
版权声明：本文为优快云博主「cqszpx」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。原文链接：https://blog.youkuaiyun.com/cqszpx/article/details/123052072。注：stattype_locked为空代表统计信息未锁定，为all表示表的统计信息被锁。异常原因：查询test表统计信息stattype_locked值，发现统计信息被锁定。在手工更新统计信息时，报ORA-20005异常。处理方案：将统计信息解锁，然后在执行更新。
oracle 由于impdp 引起的表统计信息被锁 ORA-20005: object statistics are locked
li_dongliang的专栏
07-09 2099
发现一个用户下统计信息没有生成, 查询user_tab_modifications 发现变动信息也超过10% 没有警告日志 执行 exec dbms_stats.gather_schema_stats(ownname => 'test',granularity => 'ALL',cascade => true); 还是没有生成 然后执行报 begin dbms_stats.g
ORA-20005 统计信息被锁定
cqszpx的博客
02-21 2822
在手工更新统计信息时，报ORA-20005异常 SQL>exec dbms_stats.gather_table_stats('SYS','TEST'); BEGINdbms_stats.gather_table_stats('SYS','TEST'); END; * ERRORat line 1: ORA-20005:object statistics are locked (stattype = ALL) ORA-06512:at "SYS.DBMS_STATS", line 2428
ORA-20005: object statistics are locked
cuizhu0832的博客
02-08 189
链接：http://www.eygle.com/archives/2009/11/sap_stat_locked.html 站内相关文章|Related Articles 如何检查GATHER_S...
Oracle统计信息锁,oracle 由于impdp 引起的表统计信息被锁 ORA-20005: object statistics are locked...
weixin_29196891的博客
04-05 341
发现一个用户下统计信息没有生成,查询user_tab_modifications 发现变动信息也超过10%没有警告日志执行exec dbms_stats.gather_schema_stats(ownname => 'test',granularity => 'ALL',cascade => true);还是没有生成然后执行报begin dbms_stats.gather_tab...
[ORACLE] object statistics are locked 解决
huyishero的博客
08-13 1158
今天运维在执行oracle脚本时，给我说有个错误 我看了一下，对应的代码是 dbms_stats.delete_table_stats(userName,tableName); 上网搜索了一下，是因为这张表的统计信息被锁了。 解决方案是： 用户的所有表解锁，DBMS_STATS.UNLOCK_schema_STATS('用户名'); 单张表解锁，dbms_stats.unlock_t...
统计信息锁定
03-07 310
在导入成功后我要收集下这些表的信息，结果发现好几张表都没法收集，用DBMS_STATS包显示ORA-20005：object statistics are locked (stattype = ALL)，用Analyze命令显示ORA-38029： 对象统计信息已锁定。这里不在生成的sql中用动态的user是为了让执行者明确知道到底是解锁哪个schema下的表，防止误操作。exec dbms_stats.unlock_table_stats(user,'表名');解决办法很明确，就是解锁。
ORA-28000：the account is locked
最新发布
04-01
### 解决ORA-28000: the account is locked的方法 在遇到 `ORA-28000: the account is locked` 错误时，表示尝试登录的用户账户已被锁定。以下是几种常见的解决方案： #### 方法一：通过PL/SQL Developer或其他图形化工具解锁 可以使用PL/SQL Developer等图形化工具来执行解锁操作。首先以管理员身份（如SYS或SYSTEM）登录到数据库，然后运行以下语句解锁指定用户[^1]。 ```sql ALTER USER username ACCOUNT UNLOCK; ``` 这里的 `username` 是指被锁定的具体用户名。 --- #### 方法二：通过SQL脚本解锁 如果无法直接使用图形界面工具，则可以通过命令行输入SQL脚本来完成解锁过程。具体步骤如下： 1. 打开命令提示符并切换至Oracle环境。 2. 使用具有DBA权限的用户登录数据库： ```bash sqlplus / as sysdba ``` 3. 输入解锁命令： ```sql ALTER USER username ACCOUNT UNLOCK; ``` 4. 验证用户是否已成功解锁，可通过查询 `dba_users` 表中的状态字段确认： ```sql SELECT username, account_status FROM dba_users WHERE username = 'USERNAME'; ``` 若返回的结果显示 `ACCOUNT_STATUS` 列为 `OPEN`，则表明用户已经被成功解锁[^2]。 --- #### 方法三：重置密码并解锁 有时除了简单地解除锁定外，还需要更改用户的密码以增强安全性。这一步骤也可以在同一会话中完成： ```sql ALTER USER username IDENTIFIED BY new_password ACCOUNT UNLOCK; ``` 上述命令不仅设置了新的密码 (`new_password`)，还同时解除了对该账户的锁定状态[^3]。 --- #### 注意事项 - 如果不确定哪个具体的用户被锁定了，可以查询整个数据库中所有处于锁定状态的用户列表： ```sql SELECT * FROM dba_users WHERE account_status LIKE '%LOCKED%'; ``` - Oracle默认设置下允许的最大连续失败登录次数通常为10次。一旦超出此限制，就会触发自动锁定机制作为额外的安全防护措施[^5]。 --- ### 总结 针对 `ORA-28000: the account is locked` 的处理主要包括三种途径——利用GUI工具、编写SQL脚本以及结合密码更新一起实施解锁动作。无论采取哪种方式都需要具备足够的管理权限才能顺利完成这些任务。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值