Home » Developer & Programmer » Warehouse Builder » Materialized views (oracle 10g)
Materialized views [message #315760] Tue, 22 April 2008 12:17 Go to next message
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
Re: Materialized views [message #315779 is a reply to message #315760] Tue, 22 April 2008 14:50 Go to previous messageGo to next message
Littlefoot
Messages: 18821
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;
Re: Materialized views [message #316639 is a reply to message #315760] Sat, 26 April 2008 16:19 Go to previous message
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..
Previous Topic: Connecting to db2 source from OWB through Generic connectivity
Next Topic: How to start all OWB services
Goto Forum:
  


Current Time: Wed Apr 16 10:02:36 CDT 2014

Total time taken to generate the page: 0.09780 seconds