早上用TOAD准备给一张表添加字段,为了以后方便,字段的位置我也做了改变,于是必须删表后重建.
报这个错误:
SQL0950N The table or index cannot be dropped because it is currently in use
在IBM网站上找到的错误提示:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=%2Fcom.ibm.db2.luw.messages.sql.doc%2Fdoc%2Fmsql00950n.html
SQL0950N
不能删除表或索引，因为当前正在使用。
说明
当打开的游标正在使用表或索引时，不能发出 DROP TABLE 或 DROP INDEX 语句。
不能处理该语句。未删除表或索引。
用户响应
关闭任何需要的游标并重新提交该语句。
sqlcode
：-950
sqlstate
：55006
于是拼命找哪个地方用了游标... 发现没有.
嗯,最后把TOAD关掉,用QC连接数据库,删表成功.
分析:
TOAD有个功能,查询的时候只显示前200行(自己设置),但是你可以用鼠标滚轮滚动,再显示后面的字段.
也就是说,查询的时候它用游标一直占着这表呢.
我回忆了一下,几次尝试删除前我都先查询了一下.可能就是这个问题.
阿门.悲剧.
分享到：
相关推荐
This is believed to be a bug in the Windows clipboard and a work around hasn't been found yet. * Asynchronous targets appears to be broken in the current release. * When TDropFileTarget....
[1] This paper will provide such a project model and is donated to the FreeBSD Documentation project where it can evolve together with the project so that it can at any point in time reflect the way ...
I first met the Oracle RDBMS some time in 1988, or possibly 1987, when my manager dumped a small box on my desk and said something like: “There’s this new product called Oracle just coming into the...
LinqConnect is a fast and easy-to-use ORM solution, developed closely to the Microsoft LINQ to SQL technology, and supporting SQL Server, Oracle, MySQL, PostgreSQL, and SQLite. It provides a powerful ...
in CONFIG SYS or it can load later in AUTOEXEC BAT or by user command DOS can copy critical programs and data to the RAMdisk where they will be read or written at memory speed If loaded after ...
This book introduces important concepts in the analysis and design of control ...the reader to find the inverses of n x n matrices that may be involved in the analysis and design of control systems.
part because the book seemed long enough without them but also because implementation of these modules is still incomplete I feel it"s important to keep the book focused on currently supported ...
// Element is dropped into the list from another list onAdd: function (/**Event*/evt) { // same properties as onEnd }, // Changed sorting within list onUpdate: function (/**Event*/evt) { // ...
Drop Handler - Add clipboard formats to a file object when it is copied to the clipboard or dragged and dropped. At first this seems like not a very useful extension but check out the demo. This one ...
This is true as long as the Framework does not support more than one form as it currently. The control provides three accessors: LoginID, Password, and IsRememberPassword of user input, which you ...
If the replacer parameter is an array of strings, then it will be used to select the members to be serialized. It filters the results such that only members with keys listed in the replacer array ...
off. B)The Edwards should cut down on their living expenses. C)It'll be unwise for the Edwards to buy another house. D)It's too expensive for the Edwards to live in their present house. ...
Each marker can be dragged and dropped to change the order of markers and to insert the marker text into the editor. Selecting the Customize Markers from the menu allows you to change the details ...
+ Previously undocumented logical functions can be used in the user-defined models. See the help documentation. + Current filename now appears in the title bar. + QuickCalc has been expanded to ...
Some of the techniques we presented in the first edition have become obsolete because the C++ language now offers more direct ways of achieving the same effects. Those techniques have been dropped (or...
The Applet API in JDK9 has been deprecated and all modern browsers either have discontinued or will discontinue the support for the Java plug-in, which is needed to run applets. I consider the Applet...
If files are dropped by File Delete Absolutely, they can not be recovered by the most powerful file recovery tools in the world. Therefore, please be used to deleting file by the software File ...
The word "new" was dropped from the title with the Second Edition in 2003.[1] This dictionary is not based on the Oxford English Dictionary and should not be mistaken for a new or updated version of ...
configuration space, now it is merged into the LOGIO configuration space as directed by the spec. See core User Guide for map of configuration space. - Recommended modifications to Example Design...
The pair of tributaries (incoming and outgoing) only uses capacity along the spans between the nodes where the pair is added and dropped. Thus, as illustrated in Figure 6-1, the pattern that these ...