Technical Notes

We're all on the same page!

Showing posts with label ss. Show all posts
Showing posts with label ss. Show all posts
Wednesday, 26 October 2016

How to define snapshot and synonym?

›
Define source table at DB1 machine CREATE TABLE t_alper_source AS    SELECT * FROM employees; ALTER TABLE t_alper_source ADD CONSTRAIN...
Tuesday, 25 October 2016

What are the snapshot (Materialized Views) refresh methods?

›
begin DBMS_SNAPSHOT.REFRESH( 'v_alper_ss','f');  end; / f -> fast refresh ? -> force refresh c -> comple...
›
Home
View web version
Powered by Blogger.