-
1. Re: Not able to fetch updated schema or not able to read latest values of data source.
rareddy Apr 21, 2016 8:45 AM (in response to nish18)Nishant,
If you are using resultset caching like
/*+cache*/ select * from employee
or you tuned on the materialization on the "employee" table, then the results would be cached and served the next time from cache, otherwise the query will always go the source to fetch the results.
As far as schema, if you are using the Dynamic VDB with native metadata loader (default), the schema is fetched during the deploy time and will be cached for the life of the VDB or until server restarts. There is an option to cache this schema to survive the server restarts too. If you are using the Designer based VDB, then schema is fetched during the development time and will be same until the VDB itself is updated with new updates.
HTH. Let us know if you have any questions.
Ramesh..
-
2. Re: Not able to fetch updated schema or not able to read latest values of data source.
nish18 Apr 22, 2016 9:15 AM (in response to rareddy)Thanks Ramesh ,
So does it mean that after deploying VDB , if schema changes, we need to deploy VDB again or restart a server , or we can still fetch a latest schema without deploying or restarting server ?
-
3. Re: Not able to fetch updated schema or not able to read latest values of data source.
rareddy Apr 22, 2016 10:38 AM (in response to nish18)If you are using the Dynamic VDB, with native metadata loader (i.e. did not hard code the DDL in the file), then you can use Admin API's restartVDB method, to reload a particular model, however this amounts to a re-deploy of a VDB. If the concern is, existing users connected to the old VDB, there is provision to not dis-connect all those users, but move them to the updated VDB as along the VDB name is same.
Ramesh..