对表进行任何操作都不被允许,提示SQLSTATE=57016 SQLCODE=-668 ,原因码 "7"的错误:SQL0668N Operation not allowed for reason code "7" on table XXX. 解决方法为:执行命令:reorg table XXX;即可。
参考原文为:
Operation not allowed for reason code reason-code on table table-name.
Explanation: Access to table table-name is restricted. The cause is based on the following reason codes reason-code: 7
The table is in the reorg pending state. This can occur after an ALTER TABLE statement containing a REORG-recommended operation.7
Reorganize the table using the REORG TABLE command (note that INPLACE REORG TABLE is not allowed for a table that is in the reorg pending state).
其中:
reorg table <tablename> 通过重构行来消除“碎片”数据并压缩信息,对表进行重组。
runstats on table <tbschema>.<tbname> 收集表 <tbname> 的统计信息。
reorgchk on table all 确定是否需要对表进行重组,对于对所有表自动执行 runstats 很有用。
>>> reorg 和runstats 都是单个表优化,初始化的命令:
runstats on table administrator.test;
reorg table administrator.test;
分享到:
相关推荐
BOLD FOR DELPHI * VERIFYING THAT THE UPDATE WAS SUCCESSFUL * FILES INSTALLED BY THIS UPDATE =======================================================INSTALLING THIS UPDATE* This update can not be ...
+ For some reason, the help file didn't have any single or double quotes in it. This has been corrected, so it is now easier to read. + The help file was not terminated when CurveExpert was. Fixed....
自己在用的就这个~!~! [eaccelerator] ...eaccelerator.shm_size = "0" ...eaccelerator.enable = "1" eaccelerator.optimizer = "1" eaccelerator.debug = 0 ...eaccelerator.allowed_admin_path = "
directories that will not be allowed to be processed by Diskeeper. Event Logging ------------- Diskeeper records information about its activity in two ways. First, general information about ...
NR5G网络拒绝码-5gmm_cause = 7 (0x7) (5GS Service not allowed)
table. For each crash, BlueScreenView displays the minidump filename, the date/time of the crash, the basic crash information displayed in the blue screen (Bug Check Code and 4 parameters), and the ...
// Maximum stretch distance for the slingshot let strength = 0.00161; // Strength of the slingshot force let simulationSpeed = 0.8; // Simulation speed (1 is normal) let interactRadius = 50; // ...
设置隐试打开PPT报错 Hiding the application window is not allowed
Note: People who wrote portable scripts should not depend on this ini ; directive. Instead, explicitly set the output handler using ob_start(). ; Using this ini directive may cause problems unless ...
repositories, which is absolutely NOT ALLOWED under any precedence. ======================================================================= THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ...
Android WebView 报 Not allowed to load local resource错误的解决办法 博客地址:http://blog.csdn.net/yuzhiqiang_1993/article/details/76228541
You are not allowed to change any of the ChessLib code. Extend the program as required. Use Object Oriented Design and Modeling appropriately for extensibility. Please supply all the code for your...
从3GPP协议和UE端行为分析5G gmm cause #27的网络问题
主要介绍了php采用curl访问域名返回405 method not allowed提示的解决方法,需要的朋友可以参考下
64. throw new SecurityException("The extension of the file is not allowed to be uploaded (1010)."); 65. if(m_maxFileSize > (long)0 && (long)((m_endData - m_startData) + 1) > m_maxFileSize) 66. ...
Docker-Compose_LEPP Nginx,Gunicorn,Django,PostgreSQL초기설정 pip install settings/requirements.txt django-admin startproject project project/project/settings 수정 import os...SECRET_KEY = os ....
is required for each machine that the SOFTWARE will reside on. Every machine installing, running and/or using the software for development purposes must have a licensed copy and its appropriate ...
In some setups, however, this is not allowed, which causes WP-o-Matic to exit unexpectedly when fetching large feeds. You can try changing this setting via the .htaccess file or by contacting your ...
Host 主机名 is not allowed to connect the mysql server 原因:没有授权远程访问mysql 解决方法: cmd 中运行mysql -u root -p(如果报mysql 不是内部或外部命令,找到安装mysql对应的bin文件夹运行mysql.exe,...
leak on some Windows 7/x64 systems. * Version 1.96: o Fixed bug: CurrPorts randomly failed to display remote port numbers of IPv6 connections. * Version 1.95: o Added 'Use DNS Cache For Host ...