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: APPLSYS.AD_SNAPSHOTS

Object Details

Object Name:	AD_SNAPSHOTS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	AD.AD_SNAPSHOTS
Subobject Name:
Status:	VALID

AD_SNAPSHOTS holds information about file-system snapshots.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AD_SNAPSHOTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SNAPSHOT_ID
AD_SNAPSHOTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SNAPSHOT_NAME APPL_TOP_ID SNAPSHOT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
SNAPSHOT_ID	NUMBER		Yes	PK
RELEASE_ID	NUMBER		Yes	Identifies the release to which this snapshot pertains
APPL_TOP_ID	NUMBER		Yes	Identifies the APPL_TOP to which this snapshot pertains
SNAPSHOT_NAME	VARCHAR2	(80)	Yes	Name of the snapshot. "CURRENT_VIEW"=>current-view. "PRESEEDED..."=>preseeded baseline info
SNAPSHOT_CREATION_DATE	DATE		Yes	Date when snapshot was first taken
SNAPSHOT_UPDATE_DATE	DATE		Yes	Date when snapshot was updated
SNAPSHOT_TYPE	VARCHAR2	(1)	Yes	C=>current-view. S=>named snapshot. B=>preseeded baseline info
COMMENTS	VARCHAR2	(1996)		Comments
RAN_SNAPSHOT_FLAG	VARCHAR2	(1)	Yes	Y=>adadmin's snapshot utility has been run atleast once to take a complete snapshot
IMPORTED_FLAG	VARCHAR2	(1)		Not currently used
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Query Text

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


SELECT SNAPSHOT_ID
,      RELEASE_ID
,      APPL_TOP_ID
,      SNAPSHOT_NAME
,      SNAPSHOT_CREATION_DATE
,      SNAPSHOT_UPDATE_DATE
,      SNAPSHOT_TYPE
,      COMMENTS
,      RAN_SNAPSHOT_FLAG
,      IMPORTED_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
FROM APPLSYS.AD_SNAPSHOTS;

Dependencies

[top of page]

APPLSYS.AD_SNAPSHOTS does not reference any database object

APPLSYS.AD_SNAPSHOTS is referenced by following:

APPLSYS: AD_SNAPSHOTS#