RE: SNAPSHOTS vs MATERIALIZE VIEWS

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Fri, 21 Dec 2001 12:58:00 -0800
Message-ID: <F001.003E2049.20011221114520@fatcity.com>

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 keeping a copy at the office and a copy at home. I have yet to read my Oracle documentation via the internet.

-----Original Message-----

Jared.Still_at_radisys.com
Sent: Friday, December 21, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L

Your internet connection is down?

How are you reading this?

Jared

                    tday6_at_csc.com
                    Sent by:             To:     Multiple recipients of list
ORACLE-L <ORACLE-L_at_fatcity.com>
                    root_at_fatcity.c       cc:
                    om                   Subject:     SNAPSHOTS vs

MATERIALIZE VIEWS

                    12/21/01 09:25
                    AM
                    Please respond
                    to ORACLE-L

Oracle 8.1.6.0

We're trying to recreate our snapshots. We used the syntax 'CREATE SNAPSHOT'. The snapshots won't refresh. Error message is ORA-12018.

Everyone's gone for Christmas with their office's locked (documentation inside!) and the internet connection is down. So 'R'ing TFM is out of the question.

Any ideas?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: tday6_at_csc.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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kimberly Smith
INET: ksmith2_at_myfirstlink.net

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