Is it possible in Oracle SQLDeveloper to prefetch certain tables’ metadata and keep it cached locally ?

Question

I am working on a remote database which has several master tables. the meta-data & the actual data in these tables changes rarely. When querying DB involving these tables and using certain functions (Ex: ctrl+space to auto-complete a table/column name), it takes too long to query the remote DB to fetch this data since its not cached locally.

Is there any extension/plug-in/configuration in SQLDeveloper to do this.
(Oracle SQLDeveloper Version 1.5.1 Build MAIN-5440)

Answer 1

1. Try to update to version 2.1

2. Use a tool like SQuirreL to build your queries and then copy them into SQLDeveloper. SQuirreL caches the metadata.

Answer 2

You could create a view on the local DB, that would keep the metadata local.