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

TABLE: SYS.TSDP_POLICY$

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

Stores TSDP policy information

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: TSDP_POLICY$PK
  1. ColumnPOLICY#
Unique Key: TSDP_POLICY$UK
  1. ColumnNAME
Indexes
Index Type Uniqueness Tablespace Column
TSDP_POLICY$PK NORMAL UNIQUE TablespaceSYSTEM ColumnPOLICY#
TSDP_POLICY$UK NORMAL UNIQUE TablespaceSYSTEM ColumnNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
TableTSDP_ASSOCIATION$ TSDP_ASSOCIATION$FKPO TSDP_POLICY$ TSDP_ASSOCIATION$ POLICY#
TableTSDP_SUBPOL$ TSDP_SUBPOL$FK TSDP_POLICY$ TSDP_SUBPOL$ POLICY#
Columns
Name Datatype Length Mandatory Comments
POLICY# NUMBER
Yes Dictionary number of the policy
NAME VARCHAR2 (128)
Name of the policy
SEC_FEATURE NUMBER
Yes The security feature associated with the policy
Query Text

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


SELECT POLICY#
,      NAME
,      SEC_FEATURE
FROM SYS.TSDP_POLICY$;

Dependencies

[top of page]

SYS.TSDP_POLICY$ does not reference any database object

SYS.TSDP_POLICY$ is referenced by following:

SchemaSYS
ViewDBA_TSDP_POLICY_CONDITION
ViewDBA_TSDP_POLICY_FEATURE
ViewDBA_TSDP_POLICY_PARAMETER
ViewDBA_TSDP_POLICY_PROTECTION
ViewDBA_TSDP_POLICY_TYPE