OraFAQ Forum: Data Integration » Materialized views

Home » Developer & Programmer » Data Integration » Materialized views (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Materialized views [message #315760]

Tue, 22 April 2008 12:17

aarti81
Messages: 235
Registered: December 2007
Location: USA

Senior Member

Hi all
I was trying to import a materialized view, but i dont see any option to import the materialized view. When i click on import me , it just showsme the tables,external tables,views,sequences. Please any advice on this matter is greatly appreciated.

Thanks

Report message to a moderator

Re: Materialized views [message #315779 is a reply to message #315760]

Tue, 22 April 2008 14:50

Littlefoot
Messages: 21688
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know anything about Warehouse Builder, but - this *might* be used as a workaround (at least, I believe so): as tables are valid "import" source, could you, perhaps, create a table using the CTAS method and import it (instead of a materialized view)?

CREATE TABLE my_table AS
  SELECT * FROM materialized_view;

Report message to a moderator

Re: Materialized views [message #316639 is a reply to message #315760]

Sat, 26 April 2008 16:19

ramya.pathak
Messages: 15
Registered: August 2007

Junior Member

Hi Aarti,
Which version of OWb u are using. Am using OWB 10g. And I can see clear optin to import materialized view..

Report message to a moderator

Previous Topic:	Connecting to db2 source from OWB through Generic connectivity
Next Topic:	How to start all OWB services

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 24 22:02:08 CDT 2021