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


TABLE: SYS.PROFNAME$

Object Details
Object Name: PROFNAME$
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_PROFNAME NORMAL UNIQUE TablespaceSYSTEM ColumnNAME
Columns
Name Datatype Length Mandatory Comments
PROFILE# NUMBER
Yes
NAME VARCHAR2 (128) Yes
FLAGS NUMBER
Yes
Query Text

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


SELECT PROFILE#
,      NAME
,      FLAGS
FROM SYS.PROFNAME$;

Dependencies

[top of page]

SYS.PROFNAME$ does not reference any database object

SYS.PROFNAME$ is referenced by following:

SchemaSYS
ViewDBA_PROFILES
ViewDBA_USERS
ViewDBA_XS_USERS
ViewEXU7PRF
ViewEXU7USR
ViewEXU8PRF
ViewEXU8USR
ViewKU$_PROFILE_VIEW
ViewKU$_USER_BASE_VIEW
ViewKU$_XSPRIN_VIEW
ViewUSER_PASSWORD_LIMITS
ViewUSER_XS_PASSWORD_LIMITS