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


TABLE: SYS.PROFILE$

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_PROFILE NORMAL NONUNIQUE TablespaceSYSTEM ColumnPROFILE#
Columns
Name Datatype Length Mandatory Comments
PROFILE# NUMBER
Yes
RESOURCE# NUMBER
Yes
TYPE# NUMBER
Yes
LIMIT# NUMBER
Yes
Query Text

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


SELECT PROFILE#
,      RESOURCE#
,      TYPE#
,      LIMIT#
FROM SYS.PROFILE$;

Dependencies

[top of page]

SYS.PROFILE$ does not reference any database object

SYS.PROFILE$ is referenced by following:

SchemaSYS
ViewDBA_PROFILES
ViewDBA_USERS
ViewDBA_XS_USERS
ViewEXU7PRR
ViewEXU8PRR
ViewKU$_PROFILE_ATTR_VIEW
ViewKU$_PWDVFC_VIEW
ViewUSER_PASSWORD_LIMITS
ViewUSER_RESOURCE_LIMITS
ViewUSER_USERS
ViewUSER_XS_PASSWORD_LIMITS