| Materialized views [message #315760] |
Tue, 22 April 2008 12:17  |
aarti81
Messages: 60
Registered: December 2007
Location: USA |
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  |
Littlefoot
Messages: 5640
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
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 |
ramya.pathak
Messages: 14
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..
|
|
|
]
Members
Search
Help
Register
Login
Home
