Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

alter materialized view

inDiscoverFeb 19 2014 — edited Feb 20 2014


Guys,

I had created a materialized view. For example as below.

CREATE MATERIALIZED VIEW schema.mat_repo_view

BUILD IMMEDIATE

REFRESH COMPLETE

ON DEMAND

disable query rewrite

as

select * from table1

I need to alter this view to change my query inside this view. So can I use the alter syntax as below.

ALTER MATERIALIZED VIEW new_employees

AS

select * from table2.

Or do I need to use the same parameters (like refresh clause , build clause etc....) as I used while creating my View. Or I need to specify the sames clauses again while altering the view.(like refresh clause , build clause etc....)

Thanks

Comments

800241
Hi All,
I have developed a simple web application using
JApplet, Servlet, JDBC etc. I am using JDK 1.5.06 and
Netbeans 5.0, Apache Tomcat server 5.5.
Through Netbeans IDE, I can build my project
successfully. ( NetBeans --> Build --> Build Main
Project) Now what to do, to run this application
through Internet Explorer?
rankly saying, I don't know how to deploy this .war
files (or others), so that from a remote/client
machine my friends also can access my web
application?
Please help me, I am very new to this technology.
Thanks in advance.
Wriju
To deploy a .war file you will need to be running something such as tomcat or Jboss or Sun Java System Application Server.
807599
The OP is running tomcat.

Rather than asking here look at the documentation for tomcat.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 20 2014
Added on Feb 19 2014
3 comments
802 views