Re: [Squirrel-sql-users] system tables missing from code completion? (USER_TABLES etc.)
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: agostonbejo <be...@ya...> - 2007-12-04 08:52:30
|
manningr wrote: > > On Nov 30, 2007 4:55 AM, agostonbejo <be...@ya...> wrote: >> >> Hi! >> >> Ever since the version 2.3.1 code completion does not offer the system >> tables anymore. I.e. if I type: >> >> SELECT * FROM USER_TABL<ctrl+enter> >> >> In 2.2 I get as suggestion USER_TABLES and USER_TABLESPACES. In 2.3.1 and >> 2.6 I get nothing in that case. This applies to all the system tables - >> they >> are just missing. >> >> Is this a matter of some setup option? In that case, where can I enable >> system tables in code completion? > > I believe it is a matter of configuration. At least I could reproduce > the behavior, and then go on to fix it. For startup performance, > fine-grain control was introduced to allow you to specify which > schemas are loaded. This is a big deal for Oracle as it has many > schemas which are rarely used and some that are used occasionally that > have tons of objects in them (e.g. SYS). You can control this > configuration per alias as follows: > > 1. Right-click the alias and choosing "Alias Properties". > 2. In the "Schemas" tab of the resulting dialog, choose "Specify > Schema loading and caching". > 3. Click the "Connect database to refresh Schema table" button. For > each schema listed you can specify whether or not tables, views and/or > procedures are pulled in, by click the cell in Tables, Views, or > Procedures. > 4. Turn off all schemas and then explicitly add the ones you need for > this particular alias. You can achieve this easily with the buttons > below the schema table. It forms a sentence that should read "Set > <All Objects> in all Schema to <Don't load>", then click Apply. All > Table, View and Procedure cells move to "Don't load" value. > 5. Find your schema and change the Tables, Views and Procedures cells > for that row to "Load ..." (caching will help if you have a large > number of objects that are always present) > 6. Next you will want to load VIEWS for the SYS schema. > > Start a new session and you should see system views such as USER_TABLES > now. > > Rob > > Hi! Thanks for the hint. The problem wasn't exactly that, but the option to blame was somewhere around there: if you go to the "Oracle" tab in the Alias Properties window, you've got to check an option other than "Allow accessible schemas excluding SYS" - which was set for me. I've set "Allow accessible schemas and SYS" and voila - USER_TABLES and stuff are offered in the code completion. (And the session does take considerably more time to load now, but that's no problem for me personally.) Thank you! Agoston -- View this message in context: http://www.nabble.com/system-tables-missing-from-code-completion--%28USER_TABLES-etc.%29-tf4902148.html#a14146881 Sent from the squirrel-sql-users mailing list archive at Nabble.com. |