eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: DDR.DDR_U_MV_RFRSH_LOG

Object Details

Object Name:	DDR_U_MV_RFRSH_LOG
Object Type:	TABLE
Owner:	DDR
Subobject Name:
Status:	VALID

This table is for internal use only. It is used to log the materialized view refresh information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
REFRESH_JOB_ID	VARCHAR2	(30)	The refresh job id. It can be used to group all the materialized view refresh done as a batch
REFRESH_SEQUENCE	NUMBER		This sequence number provides the sequence in which the materialized views are refreshed within and across the refresh job id
MV_NAME	VARCHAR2	(4000)	Materialized view name. This could be comma separated list of materialized views
REFRESH_METHOD	VARCHAR2	(400)	Refresh method. Complete or Fast
ERROR_MESSAGE	VARCHAR2	(4000)	Any error message associated with the processing caught by exception handler
START_DATE	DATE		Start time for the materialized view refresh
END_DATE	DATE		End time for the materialized view refresh
REFRESHED_BY	VARCHAR2	(30)	This field can be used to record user performing the materialized view refresh

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REFRESH_JOB_ID
,      REFRESH_SEQUENCE
,      MV_NAME
,      REFRESH_METHOD
,      ERROR_MESSAGE
,      START_DATE
,      END_DATE
,      REFRESHED_BY
FROM DDR.DDR_U_MV_RFRSH_LOG;

Dependencies

[top of page]

DDR.DDR_U_MV_RFRSH_LOG does not reference any database object

DDR.DDR_U_MV_RFRSH_LOG is referenced by following:

APPS: DDR_U_MV_RFRSH_LOG