A friendly place for programming greenhorns!
Big Moose Saloon
Search
|
Java FAQ
|
Recent Topics
Register / Login
Win a copy of
The Mikado Method
this week in the
Agile and other Processes
forum!
JavaRanch
»
Java Forums
»
Databases
»
JDBC
Author
Refresh Materialized View though Java
sankar
Greenhorn
Joined: Jan 28, 2003
Posts: 4
posted
Jul 08, 2008 05:38:00
0
How to refresh the materialized view from
java
code?
The following code using the spring
jdbc
support worked..
String
materiallizedViewSQL= "call dbms_snapshot.refresh('"+materiallizedView+"','C')";
getJdbcTemplate().update(materiallizedViewSQL);
[ July 08, 2008: Message edited by: sankar ]
David O'Meara
Rancher
Joined: Mar 06, 2001
Posts: 13459
I like...
posted
Jul 08, 2008 05:49:00
0
"sankar",
Welcome to the JavaRanch.
We're a friendly group, but we do require members to have
valid display names
.
Display names must be two words: your first name, a space, then your last name. Fictitious names are not allowed.
Please
edit your profile
and correct your display name since accounts with invalid display names get deleted.
Please note this is your third and final warning.
/Dave
I agree. Here's the link:
http://aspose.com/file-tools
subject: Refresh Materialized View though Java
Similar Threads
Another way to get the information needed
Materialized Views in oracle
Oracle job is not running automatically
Can i create Materialized view on a Materlized view.
Materialized view
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter