Re: Snapshot Refresh Question

Calvin,

This is generic bug 557451 (not fixed until 8.1.7). The workaround is to check LAST_REFRESH in DBA_SNAPSHOT_REFRESH_TIMES instead.

HTH,

• Anita

>From: Calvin Lim <calvin-lim_at_mediaring.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Snapshot Refresh Question
>Date: Mon, 08 May 2000 17:06:06 -0800
>
>Hi folks,
>
>I've created a snapshot with the following steps.
>
>1. created dblink to master database
>2. create snapshot log on master database table, something like...
> create snapshot log on TAB_NAME
> tablespace DATA
> storage(initial 128K next 50K pctincrease 0)
> pctfree 5 pctused 90;
>3. create snapshot on DB to hold snapshot, something like...
> create snapshot SNAPNAME
> pctfree 5
> tablespace SNAP
> storage (initial 1024K next 128K pctincrease 0)
> refresh fast
> start with sysdate
> next sysdate+1
> as select * from TAB_NAME;
>
>I can refresh the snapshot manually and successfully using...
> execute DBMS_SNAPSHOT.REFRESH('owner.snapname','?');
>
>At least i think its successful as new data gets brought
>across. But when i look at last_refresh from DBA_SNAPSHOTS,
>it always contains "01-Jan-1950".
>
>Problem is that snapshot does not seem to refreshing automatically.
>I've got job_queue_processes = 3, job_queue_interval = 60 in my init.ora.
>
>Can anybody tell me what i'm not doing right, what i'm missing? Thanks!
>
>Regards,
>Calvin
>
>-----BEGIN PGP PUBLIC KEY BLOCK-----
>Version: PGPfreeware 6.0.2i
>
>mQENAziIKPcAAAEIAMOziD1YcgivJCdmdMaQftSrMhnL6uXjz9Fh6c2FjDbEwLb1
>gHAYk8bdlaWLPspacuwo5mjzCc5uUvNualORP+tLxGNY9GiMdHMUfUdNLxv7EU4+
>6WxaXwyzz5DZUQiwLsvg12+ZSLOuOL4BLu8oJH9MBSPa/9aaYGDpQ845L6JJP5t1
>uDDsG26k6gnenOfT+ZaEgFTFpYQbfXN7X16dc726AcEuSG8NUjK3thA3ol9m8768
>cCELkc82w55HNH5b4TeF9obapJrXgOLqnf2pi4mUodao5dFewW/U46zPcz2giRp4
>gVPAmJFs+s8OjKY74D3aXH7QWg7bLrLOrBG3pkUABRG0L0NhbHZpbiBMaW0gU3dl
>ZSBLaGlhbmcgPGNhbHZpbl9saW1AaG90bWFpbC5jb20+iQEVAwUQOIgo9y6yzqwR
>t6ZFAQFrTAf+Lw6aI0wSfOooU1n9qw0zdL4o0U4ZH+XAgzn8BoVcv0U1bA0U1ckg
>pDY5TVfR0hQg7DQyUvh1AKxeD9D6OTFpg/TE3BPD49iq/LS3uuUbfIGmhsE6AmM1
>SiRwwmA5n5IZTWDYHrocBJegV5Hk3iHJeDjCKvX/CZCZH4CGJ/2y/THfa6I9eDfF
>kmZ8f90cM4hZ9YiqLSslNf5hztJZzEfBuSs7Zz6tHRQFlCucn5mlKPNM+ig4FBdS
>f6ISUMxQxZB2xbFwYDn+qjB6eF8HianPP7XCQUSQNJeWKQ9pkJ7QOZeEKvRYZHp2
>tLNw34pJ8cHoOIGS7FAi+OX2IfyyOvehkw==
>=FOMk
>-----END PGP PUBLIC KEY BLOCK-----
>--
>Author: Calvin Lim
> INET: calvin-lim_at_mediaring.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).