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

TABLE: SYS.TSDP_SOURCE$

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

Stores the Discovery source information

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: TSDP_SOURCE$PK
  1. ColumnSOURCE#
Unique Key: TSDP_SOURCE$UK
  1. ColumnNAME
  2. ColumnTYPE
Indexes
Index Type Uniqueness Tablespace Column
TSDP_SOURCE$PK NORMAL UNIQUE TablespaceSYSTEM ColumnSOURCE#
TSDP_SOURCE$UK NORMAL UNIQUE TablespaceSYSTEM ColumnNAME
ColumnTYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
TableTSDP_SENSITIVE_TYPE$ TSDP_SENSITIVE_TYPE$FK TSDP_SOURCE$ TSDP_SENSITIVE_TYPE$ SOURCE#
Columns
Name Datatype Length Mandatory Comments
SOURCE# NUMBER
Yes Dictionary number of the source
NAME VARCHAR2 (128)
Name of the source
TYPE NUMBER

The type of the source - ADM or DB
TS TIMESTAMP(6) (11)
Timestamp when the entry was made
Query Text

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


SELECT SOURCE#
,      NAME
,      TYPE
,      TS
FROM SYS.TSDP_SOURCE$;

Dependencies

[top of page]

SYS.TSDP_SOURCE$ does not reference any database object

SYS.TSDP_SOURCE$ is referenced by following:

SchemaSYS
ViewDBA_DISCOVERY_SOURCE
ViewDBA_SENSITIVE_COLUMN_TYPES
ViewDBA_SENSITIVE_DATA