Home » RDBMS Server » Server Administration » mview to view (11 g rel 2)
mview to view [message #574967] Thu, 17 January 2013 04:21 Go to next message
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member
can we change the existing materialized view to normal view?
if yes how?

Re: mview to view [message #574969 is a reply to message #574967] Thu, 17 January 2013 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: mview to view [message #574970 is a reply to message #574969] Thu, 17 January 2013 04:23 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Apart from dropping the MV and using its SELECT statement in CREATE VIEW? I don't think so.
Previous Topic: ORA-00054: drop MATERIALIZED view log
Next Topic: Install Oracle 11g software.
Goto Forum:
  


Current Time: Thu Mar 28 16:09:59 CDT 2024