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

TABLE: SYS.USER_HISTORY$

Object Details
Object Name: USER_HISTORY$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
USER# NUMBER
Yes
PASSWORD VARCHAR2 (4000)
PASSWORD_DATE DATE

Query Text

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


SELECT USER#
,      PASSWORD
,      PASSWORD_DATE
FROM SYS.USER_HISTORY$;

Dependencies

[top of page]

SYS.USER_HISTORY$ does not reference any database object

SYS.USER_HISTORY$ is referenced by following:

SchemaSYS
Package BodyDBMS_PSWMG_IMPORT - show dependent code
ViewEXU8PHS
ViewKU$_11_2_PSW_HIST_VIEW
ViewKU$_PSW_HIST_LIST_VIEW
ViewKU$_PSW_HIST_VIEW
Package BodyXS_PRINCIPAL_INT - show dependent code