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

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

-------------------------------------------------------------------------
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