Code Assistant not working without Schema Prefix

[Shubham]

Hi

I rely heavily on the code assistant to complete my tables et al, and cant seem to make it work the way I want:

Using the below sequence:

1) ALTER SESSION SET SCHEMA_NAME = MYSCHEMA;
2) SELECT * FROM

;
3) SELECT * FROM MYSCHEMA.

;

If I dont put in Step 1, Step 2 doesn't work.

After running Step 1, Step 2 works but code assistant drop down doesnt appear - This is the main bone of contention.

Step 3 takes abnormally long for the code assistant drop down to appear every time I type until the period.

I understand this could be something related to synonyms et al, but this same thing works like a charm in SQL Developer (which is anyway legacy-wise slow)

Could you please help me to understand, is there a permission issue here?

 

[Marco Kalter]

The Code Assistant takes a snapshot of all available object names when you make a connection to the database. It does not take a new snapshot when you execute an "alter session set schma_name" command (it is a time consuming set of queries).

 

[Arky]

Marco,
I'm also interested on this. Could you consider adding a "refresh objects" or something option in order to manually handle these cases? Or is there another workaround?

 

[Maxmix]

I don't know how, but if it would be possible... to have tiny button somewhere which will execute:
"ALTER SESSION SET SCHEMA_NAME = "

where is currently selected USER in the corresponding Object Browser dropdown list, or currently connected USER if the item selected is "ALL USERS"

 

[Shubham]

@Marco

Is it possible that I dont have access to some system table, gaining which will help in a faster dropdown?
Also, why can I access the drop down only when I use the schema name explicitly and not otherwise?

Regards,
Shubham