Re: system tables missing from code completion? (USER_TABLES etc.)

manningr wrote:
> 
> On Nov 30, 2007 4:55 AM, agostonbejo <bejoag1@xxxxxxxxx> 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.


-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell.  From the desktop to the data center, Linux is going
mainstream.  Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4