Thanks to all who replied...
santosh
-Original Message-
Sent: Tuesday, March 11, 2003 8:13 PM
To: Santosh Varma; Multiple recipients of list ORACLE-L
Santosh,
I see that someone else has pointed you to an Oracle Tech Net document.
But
the short of it is:
Snapshot or materialize
Read this,
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/c31repli.htm#12888
Regards,
Kamaljeet Singh
(NCDB ASG)
MBT, 52
Barrack Square, Martlesham. IP5 3RF.
Off. 01473 667170
Mob. 077 5368 5370
[EMAIL PROTECTED]
-Original Message---
Eriovaldo
As I said, Oracle now refers to snapshots as materialized views. You will
need to paste the links I have provided back together.
>From the Oracle8i Replication Manual, Chapter 3, Snapshot Concepts
"Oracle uses snapshots, also referred to as materialized views"
http://download-west.ora
Dennis :
Is there any documento that explain all the resources about snapshot ?
I had read the Oracle Documentation, but when i am reading about snapshot I
don't see about index , understand ?
I would like a document specific about snapshot.
Regards
Eriovaldo
- Original Message -
To
Eriovaldo - Oracle is moving to referring to snapshots as materialized
views, and yes you can put an index on them.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, October 30, 2002 7:04 PM
To: Multiple recipients of list ORACLE-L
Frie
It does explain why you can't find a good comparison though:-)
The package for materialized views is actually the snap shot
packages. Just a public synonym that makes it look different
(at least in 8i).
-Original Message-
Carlson
Sent: Thursday, March 14, 2002 9:25 AM
To: Multiple recip
Now on to CREATE TABLESPACE TEMPORARY and
CREATE TEMPORARY TABLESPACE...
(Note:160426.1)
>>> [EMAIL PROTECTED] 03/14/02 12:25PM >>>
Isn't that just like Oracle... Shesh
Todd
-Original Message-
Kevin M
Sent: Thursday, March 14, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L
ma
Isn't that just like Oracle... Shesh
Todd
-Original Message-
Kevin M
Sent: Thursday, March 14, 2002 10:34 AM
To: Multiple recipients of list ORACLE-L
materialized views are snapshots
snapshots are materialized views.
Any questions?
-Original Message-
Sent: Thursday, March 14,
There is no difference -- a snapshot and a materialized view are the
same thing
Snapshots and snapshot logs were originally created for use with
replication, then Oracle realized how useful they could be for query
rewrite, so they renamed them materialized views.
Take a look at the docs, and
materialized views are snapshots
snapshots are materialized views.
Any questions?
-Original Message-
Sent: Thursday, March 14, 2002 10:24 AM
To: Multiple recipients of list ORACLE-L
Hello All,
Sun 5.8 Oracle 8.1.7.2
At a client site the developers are building an application that runs
Different names for the same thing. Snapshots is being phased out and the
new terminology is materialized views.
Todd Carlson
well, I organize it so that there is a folder called ORACLE DOCS under
a folder called RACHEL on the company PC. one easy delete of the
RACHEL folder and the company PC will be clean
I've also got a network at home and have started backing up that folder
to my desktop on a regular basis. I ke
I limit what I have to carry with me by copying all the docs to my PC, but
only the ones that I will really use to a laptop. I won't probably use
forms and reports on the road, but I will at home. It also limits what I
have to clean off of the 'compay' shared laptop...
-Original Message--
I don't even bother with the CD, I just copy the docs to my PC. Right
now I have 7.3.4/8.0.5/8.1.7 and 9i on the machine.
doesn't take much space and since when I travel the CD is external and
therefore "optional" for me to carry, I always have the docs when I'm
writing
--- Kimberly Smith <[EMA
Jared,
Some places do have internet connections and email separated.
Fujitsu for one. Department of National Defense is another.
However, that being said, all Oracle CD box sets come with
at least one CD that contains documentation. I have 6 million
of them (roughly). I personally believe in k
I believe you will need to CREATE OR REPLACE SNAPSHOT or drop and then
recreate it.
Before dropping it, look at the view DBA_SNAPSHOTS for the contents of the
snapshot. Secondly, you can, within SQL*Plus, type HELP SNAPSHOT, and get
some syntactical help with the commands. Otherwise, you will n
Your internet connection is down?
How are you reading this?
Jared
[EMAIL PROTECTED]
17 matches
Mail list logo