Mat Views export, create as tables when imported ???

From: George Leonard <leonarge_at_vodacom.co.za>
Date: Mon, 1 Mar 2004 08:46:26 +0200
Message-ID: <99CEA8FB33554B4BAC372CE602F9B7ED0370D6D8@zamdh02001.vodacom.corp>

Hi all  

We did an export rows=n, 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  

---

 

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_at_za.didata.com
Web: http://www.didata.co.za  

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, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!   

“This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link http://www.vodacom.net/legal/email.asp "

---

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

---

To unsubscribe send email to: oracle-l-request_at_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

---

Received on Mon Mar 01 2004 - 00:44:16 CST