oracle Toad：表格自动完成功能不起作用
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/20606681/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Toad: Table Autocomplete Functionality Not Working
提问by Petteri Pertola
I've been using Toad for more than a year now without problems. All of a sudden the table autocomplete feature has ceased working. No settings have been changed, and I've clean installed a new TOAD version, yet the problem persists.
我已经使用 Toad 一年多了，没有出现任何问题。突然之间，表格自动完成功能停止工作。没有更改任何设置，我已经干净地安装了一个新的 TOAD 版本，但问题仍然存在。
The image below shows autocomplete defaulting into view IN_INSTRUMENT in schema MCDM. Normal behaviour should result in a table/view list.
下图显示了模式 MCDM 中默认进入视图 IN_INSTRUMENT 的自动完成。正常行为应该产生一个表/视图列表。
It is notable that the above does not happen with all schemas. For some schemas I will still see a table list. In the beginning this error happened only with a single schema. Now it is slowly progressing to other schemas as well, which is exceptionally frustrtating when you're dealing with dozens of schemas that contain hundreds of tables each. It slows down development when you must open Schema Browser and look for the exact table/view/procedure/package each time instead of letting autocomplete give suggestions.
值得注意的是，并非所有模式都会发生上述情况。对于某些模式，我仍然会看到一个表列表。一开始这个错误只发生在一个模式中。现在它也在慢慢地发展到其他模式，当您处理数十个模式，每个模式都包含数百个表时，这非常令人沮丧。当您每次必须打开模式浏览器并查找确切的表/视图/过程/包而不是让自动完成提供建议时，它会减慢开发速度。
This same issue has been described in this threadand and this threadwith less detail, yet no accepted answer has been given.
这个同样的问题已经被描述这个线程和与此线程较少的细节，目前还没有公认的答案已经给出。
As can be seen from Code Assist settings, these should be in order.
从 Code Assist 设置可以看出，这些应该是有序的。
How to reset autocomplete behaviour into what is its original state?
如何将自动完成行为重置为其原始状态？
采纳答案by Petteri Pertola
I've found the solution to this problem. The issue was a corrupt configuration file. For anyone else with the same problem, this is how I fixed mine:
我已经找到了解决这个问题的方法。问题是配置文件损坏。对于其他有同样问题的人，我是这样修复我的：
Backup your appdatafolder - you can find its location in options -> general -> application data.
Create a new set of user files using Utilities -> Copy User Settings -> Create clean set of user files. Make sure you are running Toad with administrator rights.
备份您的appdata文件夹 - 您可以在options -> general -> application data 中找到它的位置。
使用Utilities -> Copy User Settings -> Create clean set of user files 创建一组新的用户文件。确保您使用管理员权限运行 Toad。
Note that the above will delete all your saved connection details (schema names, passwords, connection strings), so take a note of these.
请注意，以上操作将删除您保存的所有连接详细信息（架构名称、密码、连接字符串），因此请记下这些。
Hope this helps someone in the future.
希望这对将来的人有所帮助。
回答by Steve
Under View > Toad Options > Editor > Code Assist > Toad Insight Objects, checking Synonyms (in addition to Public Synonyms) worked for me.
在“查看”>“Toad 选项”>“编辑器”>“代码助手”>“Toad Insight 对象”下，检查同义词（除了公共同义词）对我有用。
回答by Alen Oblak
Try to check "Public synonyms" in the "Toad insight objects".
尝试在“Toad 洞察对象”中检查“公共同义词”。
回答by Steven Edmunds
Go to Toad Options, and then Editor > Code Assist and uncheck "Cache Code Insight results". This made it immediately start working for me using Toad for Oracle version 9.7. I could then go back and check the box and it would still work.
转至 Toad 选项，然后选择编辑器 > 代码辅助并取消选中“缓存代码洞察结果”。这使它立即开始为我使用 Toad for Oracle 9.7 版。然后我可以回去检查这个框，它仍然可以工作。
回答by ibrahimgunes
I faced the same problem even though I set up everything mentioned above. So basically Toad does not suggest column names if I don't define the scheme name.
即使我设置了上面提到的所有内容，我也遇到了同样的问题。因此，如果我不定义方案名称，基本上 Toad 不会建议列名称。
X(schema).TABLE_NAME.(then lists all columns)
Worked for me..
对我来说有效..
