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?

Report message to a moderator

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: 68765
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No.

Regards
Michel

Report message to a moderator

Re: mview to view [message #574970 is a reply to message #574969] Thu, 17 January 2013 04:23 Go to previous message
Littlefoot
Messages: 21825
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.

Report message to a moderator

Previous Topic: ORA-00054: drop MATERIALIZED view log
Next Topic: Install Oracle 11g software.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Aug 04 05:33:10 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.