Is it possible to reload the database objects when using Code Assistant? I am working in PL/SQL Developer and then I create new tables using SQL*Plus. This new tables do not show when I is using Code Assistant. I have to close PL/SQL Developer and reopen it. Is there a option to force reload of database objects?
The new table is available for the Code Assistant when listing columns, but it is not available for auto-completion of the table name itself. The list of tables is fetched once at the start of the session. There is currently no option to reload it.
I would rather have a "reload" button than do a reconnect to the database to reload the database objects. Sometimes I have to work against customer databases and the connection has to be approved and if I have to reconnect then a new approval must be issued.
Would be fine for me, too. But i think an reload-on-create-command-option as suggested from T-Gergely would be the best way. Manually reloading is no more necassary.
I support a manual reload option, because we are working in a team on the same database, and I find it more convenient just reloading this list when one of my co-workers creates a table.
Please add this function (reload database objects) in version 10. You must have a method doing this already during startup, so it should be fairly easy to add an entry to the key configuration list.