Re: SNAPSHOT's name show up with SNAP$_ prepended ?

In article <smmvt5srnd668_at_corp.supernews.com>, Scott W <shwngDELETE_at_DELE TEaustin.rr.com> writes
>I had thought that when you create a snapshot that the name that Oracle
>creates is whatever name you give it with SNAP$_ prepended to it. For
>example
>
>CREATE SNAPSHOT mysnap REFRESH FAST ON COMMIT
> AS SELECT t.month, p.prod_name, SUM(f.sales) AS sum_sales
> FROM whatever...
>
>would create a snapshot called myschema.snap$_mysnap.

That is certainly what used to happen in v7.3 - a SNAP$_ table was created which was physically updated by the database and it also created a view with the name of the 'mysnap' table name.

Oracle 8 seems to do it differently - it creates 'mysnap' as table and another table or two to keep track of the changes (depending on whether you are using snapshot logging).

The all/user_objects just shows the snapshots as 'UNDEFINED' types, it looks like only the all/user_snapshots view tells you which tables are snapshots. Likewise with snapshot logs and the all/user_snapshot_logs view.

Andy

-- 
Andy Hardy. PGP ID: 0xA62A4849
===============================================================