quantifying snapshot refresh time & primary key.

From: Prem Gadey <prem_at_nortelnetworks.com>
Date: 2000/03/15
Message-ID: <38D00C6D.E523CC08@nortelnetworks.com>#1/1

Hi,

I am creating a snapshot of a table from a remote database. I ran the following script which took about 2 hours and then I could see the "desc snapshotname" but no rows were filled. Only next day I could see a "snapshot" of the table from remote database with all the rows filled. I would like to know when it executed and how long it took to complete the task. (I could not make sense out of the query "select name, last_refresh from dba_snapshots" as resulted "snapshotname 01-JAN-50".)

Also, as I could not create a snapshot from the remote database "using primary key" (there is no primary key for the table), I am "using rowid". Oracle documentation recommends that "rowid" should not be used in releases after Oracle 8.1. What is the problem in doing that. Is it for only performance reasons or any other reason ?

script:

---

create SNAPSHOT snapshotname
pctfree 5
tablespace "snapshottablespace"
storage (initial 100m next 50m pctincrease 0) refresh with rowid

        start with SysDate
        next SysDate + 1

as select * from remote_user.remote_table_name_at_remote_service_name;

---

Thanks for your response.

--
With regards,
/Prem
(prem_at_nortelnetworks.com)

Received on Wed Mar 15 2000 - 00:00:00 CST