snapshot 测试

@A机
create table test1 as select OBJECT_NAME,OBJECT_ID,OBJECT_TYPE,status,CREATED from user_objects;
delete from test1 where object_id is null;
commit;
alter table test1 add constraint pk_OBJECT_ID primary key (OBJECT_ID) using index;
Create snapshot log on test1;

@B机
create database link lnk_dwisd connect to etl identified by Loadlif5 using 'isddw';
Create snapshot sn_test1 as Select * From test1@lnk_dwisd;

Alter snapshot sn_test1 refresh fast Start with sysdate+1/1440 next sysdate+1/144;

SQL> set serveroutput on
SQL> exec print_table('select * from user_jobs');
select * from user_jobs
JOB : 49
LOG_USER : KYTETANG
PRIV_USER : KYTETANG
SCHEMA_USER : KYTETANG
LAST_DATE : 28-jan-2010 23:25:46
LAST_SEC : 23:25:46
THIS_DATE :
THIS_SEC :
NEXT_DATE : 28-jan-2010 23:40:44
NEXT_SEC : 23:40:44
TOTAL_TIME : 300
BROKEN : N
INTERVAL : sysdate+1/144
FAILURES : 0
WHAT : dbms_refresh.refresh('"KYTETANG"."SN_TEST1"');
NLS_ENV : NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA'
NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,'
NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY'
MISC_ENV : 0102000200000000
INSTANCE : 0
-----------------

@A机
一些delete并commit

SQL> select count(*) from test1;

COUNT(*)
----------
17

@B机

SQL> exec sys.DBMS_IJOB.run(49);

PL/SQL procedure successfully completed.

SQL> select count(*) from sn_test1;

COUNT(*)
----------
17

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/94384/viewspace-1030984/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/94384/viewspace-1030984/