Untitled

From oracle-l-bounce@freelists.org Mon Mar 1 00:44:16 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i216iGl28332 for ; Mon, 1 Mar 2004 00:44:16 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i216iGo28327 for ; Mon, 1 Mar 2004 00:44:16 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 745B5394D1D; Mon, 1 Mar 2004 01:45:03 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 01 Mar 2004 01:43:16 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mfwj032.mfw.is.co.za (mfwj032.mfw.is.co.za [196.35.77.38]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 833A6394CF6 for ; Mon, 1 Mar 2004 01:43:12 -0500 (EST) Received: from 168.210.128.88 (Not Verified[168.210.128.88]) by mfwj032.mfw.is.co.za with NetIQ MailMarshal (v5.5.4.16) id ; Mon, 01 Mar 2004 08:52:34 +0200 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by 168.210.128.88 (8.11.6/8.11.6) with SMTP id i216cgo28364 for ; Mon, 1 Mar 2004 08:38:42 +0200 Received: from zamdh02001.vodacom.corp ([10.111.7.52]) by zamdh02002.vodacom.corp with Microsoft SMTPSVC(5.0.2195.6713); Mon, 1 Mar 2004 08:46:26 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3FF58.EAFA258B" Subject: Mat Views export, create as tables when imported ??? Date: Mon, 1 Mar 2004 08:46:26 +0200 Message-ID: <99CEA8FB33554B4BAC372CE602F9B7ED0370D6D8@zamdh02001.vodacom.corp> Thread-Topic: Mat Views export, create as tables when imported ??? Thread-Index: AcP8m3Jw1V8LVU1WQr6J8ycbZ0A2cAAAAmKgAK9LhPA= From: "George Leonard" To: X-OriginalArrivalTime: 01 Mar 2004 06:46:26.0046 (UTC) FILETIME=[EAF251E0:01C3FF58] Mime-Version: 1.0 X-Mailer-Rocketseed: MTY4LjIxMC4xMjguODg= X-Mailer-Rocketseed-Counter: 1 X-archive-position: 60 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: leonarge@vodacom.co.za Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C3FF58.EAFA258B Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi all =20 We did an export rows=3Dn, when the created dump was imported these were created as tables. Some of them was created as MV's but failed to re-fresh. =20 Oracle 9.2.0.4 64 Bit on Solaris. =20 Is this a known issue/behavior. =20 =20 George =20 ________________________________________________ =20 George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:george.leonard@za.didata.com Web: http://www.didata.co.za =20 You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk,=20 Every Fool Has the Right to Kill or Injure Themselves as They See Fit! =20=20 =93This e-mail is sent on the Terms and Conditions that can be accessed b= y Clicking on this link http://www.vodacom.net/legal/email.asp " ------_=_NextPart_001_01C3FF58.EAFA258B Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Untitled

Hi all

We did an export rows=3Dn, when the = created dump was imported these were created as tables. Some of them was created = as MV’s but failed to re-fresh.

Oracle 9.2.0.4 64 Bit on Solaris.

Is this a known issue/behavior.

George

<= /span>

___________________= _____________________________

<= /span>

George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:george.leonard@za.didata.com
Web: http://www.didata.co= .za

<= /span>

You Have The Obliga= tion to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!<= br> Once Informed & Totally Aware of the Risk,
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!

=93This e-mail is sent on the Terms and Conditions that can be accessed b= y=20 Clicking on this link http://www.vodacom.net/le= gal/email.asp=20 " =00 ------_=_NextPart_001_01C3FF58.EAFA258B-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------