MSC_PHUB_DATES_MVINVALID
Hi All,
When I query from database, we found this output --
select owner, object_type, object_name, status, timestamp from all_objects where object_name like 'MSC_PHUB_DATES_MV';
Output--
APPS TABLE MSC_PHUB_DATES_MV VALID 2012-09-12:09:52:33
APPS MATERIALIZED VIEW MSC_PHUB_DATES_MV INVALID 2012-09-12:09:52:33
select owner, object_type, object_name, status, timestamp from all_objects where object_name like 'MSC_PHUB_DATES_MV';
Output--
APPS TABLE MSC_PHUB_DATES_MV VALID 2012-09-12:09:52:33
APPS MATERIALIZED VIEW MSC_PHUB_DATES_MV INVALID 2012-09-12:09:52:33
As such, we are not getting any error, but need to know whether is this correct or not. Can we drop invalid MV?
Regards
Amit
Tagged:
0