Thanks for the question, Dennis.
Asked: February 03, 2017 - 3:42 pm UTC
Last updated: February 03, 2017 - 8:30 pm UTC
Version: 11.2.0.3
Viewed 1000+ times
You Asked
I have DB user "test" that has create any context privilege.
I create a context using the command below
CREATE OR REPLACE CONTEXT apex_ctx using kvs_apex_ctx accessed globally
I created the package kvs_apex_ctx and context works fine.
If my DB restarted the context is gone and I have to manually run the create context again.
I use select * from dba_context and its not there.
I execute the create context and I can see it again.
I know its supposed to be consistent but its not, is there any other way to check why its not being save?
Thanks
and Connor said...
I'd like to see some output, ie, being
a) your create context command being created
b) shutdown/startup command output
c) a query showing your context has disappeared.
Is this answer out of date? If it is, please let us know via a Comment