Technical Notes
We're all on the same page!
Showing posts with label
snapshot
.
Show all posts
Showing posts with label
snapshot
.
Show all posts
Friday, 19 January 2018
How to define primary key on existed table?
›
e.g. steps; lock table -> add new column for primary key -> update data with counter -> define sequence -> define trigger -...
Friday, 12 January 2018
enq: JI - contention wait event solution
›
Action Synchronizing data with remote database( NEW_XE ) SQL> BEGIN DBMS_SNAPSHOT.REFRESH(LIST => 'HR.SS_EMPLOYEES_NEW',M...
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