Home » SQL & PL/SQL » SQL & PL/SQL » List Partion Index and MV expected refresh datetime (Oracle 10g)
List Partion Index and MV expected refresh datetime [message #354612] Mon, 20 October 2008 10:12 Go to next message
pointers
Messages: 410
Registered: May 2008
Senior Member
Hi,
Please advice me
1.How to List all partition indexes which are in unusable state.
2.How to List all MVs expected refresh datetime rather last refreshed time.

Regards,
Pinters.
Re: List Partion Index and MV expected refresh datetime [message #354630 is a reply to message #354612] Mon, 20 October 2008 10:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. This is in the dictionary
2. This is in the dictionary

select * from dict;


Regards
Michel
Re: List Partion Index and MV expected refresh datetime [message #354653 is a reply to message #354612] Mon, 20 October 2008 12:05 Go to previous messageGo to next message
pointers
Messages: 410
Registered: May 2008
Senior Member
Thanks micheal....
I got 'all_snapshots'..where it is mentioned next (varchar)and tart_with (date) are used to find next refresh date...
Are these columns somethig similar to interval and next_date n user_jobs.
if not what exactly it contains..?

Regards,
Pointers.


Re: List Partion Index and MV expected refresh datetime [message #354660 is a reply to message #354653] Mon, 20 October 2008 12:11 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, they are the same ones.

Regards
Michel
Previous Topic: String comparison
Next Topic: Stored Procedure Creation and Execution Questions
Goto Forum:
  


Current Time: Sat Dec 10 01:25:23 CST 2016

Total time taken to generate the page: 0.13680 seconds