Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> SNAPSHOT's name show up with SNAP$_ prepended ?
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. I realize that under 8.i that snapshots are synonymous with materialized views, but the question still stands. The Oracle docs state that "Oracle generates the names for the tables and indexes used to maintain the materialized view by adding a prefix or suffix to the materialized view name". But it doesn't state what that name is, and for the life of me, when I create one, it just ends up with the name I give it.
I am trying to figure out the most reliable way to determine what objects from all_objects are snapshots, MVs, snapshot logs, etc.
Thanks, Scott Received on Tue Jul 11 2000 - 00:00:00 CDT