Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_SNAPSHOT.REFRESH
DBMS_SNAPSHOT.REFRESH [message #251535] Sat, 14 July 2007 06:43 Go to next message
ammishra
Messages: 179
Registered: January 2007
Location: india
Senior Member
Hi,

i am looking on sql script. script is as.

BEGIN
ERP_UTIL_PKG.set_context('ERP_TK_SCHED_BACKLOG_DAILY_MV');
ERP_UTIL_PKG.begin_refresh('ERP_TK_SCHED_BACKLOG_DAILY_MV');
[CODE]DBMS_SNAPSHOT.REFRESH( 'ERP_TK_SCHED_BACKLOG_DAILY_MV','c');[/CODE]
ERP_UTIL_PKG.set_context('ERP_TK_SCHED_BACKLOG_DAILY_MV');
ERP_UTIL_PKG.end_refresh('ERP_TK_SCHED_BACKLOG_DAILY_MV','C');
END;


i am not able to understand the use of DBMS_SNAPSHOT.REFRESH. 'ERP_TK_SCHED_BACKLOG_DAILY_MV' is my table name.

--Yash
Re: DBMS_SNAPSHOT.REFRESH [message #251548 is a reply to message #251535] Sat, 14 July 2007 10:21 Go to previous messageGo to next message
Michel Cadot
Messages: 60017
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBMS_SNAPSHOT.REFRESH

Regards
Michel
Re: DBMS_SNAPSHOT.REFRESH [message #251667 is a reply to message #251548] Mon, 16 July 2007 00:34 Go to previous messageGo to next message
ammishra
Messages: 179
Registered: January 2007
Location: india
Senior Member
i know that where is document ..but i am not able to understand that's why i posted....

--Yash
Re: DBMS_SNAPSHOT.REFRESH [message #251671 is a reply to message #251667] Mon, 16 July 2007 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 60017
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why what? You don't what?

Regards
Michel
Re: DBMS_SNAPSHOT.REFRESH [message #251672 is a reply to message #251671] Mon, 16 July 2007 00:52 Go to previous messageGo to next message
ammishra
Messages: 179
Registered: January 2007
Location: india
Senior Member
why what ??
Re: DBMS_SNAPSHOT.REFRESH [message #251680 is a reply to message #251672] Mon, 16 July 2007 01:18 Go to previous message
Michel Cadot
Messages: 60017
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, wrong copy and paste.
I meant: what don't you understand?

Regards
Michel
Previous Topic: specifying Hints in SQL statement
Next Topic: oracle parallelism
Goto Forum:
  


Current Time: Mon Dec 22 09:06:04 CST 2014

Total time taken to generate the page: 0.08064 seconds