Materialized views
Oracle 11.2solaris11
we have materialized views, these are call for package and theses package are call for a process, but other proces
call the seem materializad view so a process drop the materilized view and create, but drop the record of first process,
How we can implement these cases for un process not afect other process.
example: script
the package drop view and create, these view will use for two process, the problem is on process is using and the other proces drop it, can I resolve it?
drop materializes view VISTA
CREATE MATERIALIZED VIEW VISTA
NOCACHE
LOGGING
NOCOMPRESS
NOPARALLEL
we have materialized views, these are call for package and theses package are call for a process, but other proces
call the seem materializad view so a process drop the materilized view and create, but drop the record of first process,
How we can implement these cases for un process not afect other process.
example: script
the package drop view and create, these view will use for two process, the problem is on process is using and the other proces drop it, can I resolve it?
drop materializes view VISTA
CREATE MATERIALIZED VIEW VISTA
NOCACHE
LOGGING
NOCOMPRESS
NOPARALLEL
0