OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » mview to view (11 g rel 2)

Thu, 17 January 2013 04:21

maninderkrb
Messages: 41
Registered: August 2012
Location: India

Member

can we change the existing materialized view to normal view?
if yes how?

Thu, 17 January 2013 04:22

Michel Cadot
Messages: 67769
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No.

Regards
Michel

Thu, 17 January 2013 04:23

Littlefoot
Messages: 21654
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: Tue Mar 09 04:52:57 CST 2021