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


TABLE: SYS.TRANSFORMATIONS$

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SYS_C00138949
  1. ColumnTRANSFORMATION_ID
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00138949 NORMAL UNIQUE TablespaceSYSTEM ColumnTRANSFORMATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableATTRIBUTE_TRANSFORMATIONS$ ATTRIBUTE_TRANSFORMATIONS_FK TRANSFORMATIONS$ ATTRIBUTE_TRANSFORMATIONS$ TRANSFORMATION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSFORMATION_ID NUMBER
Yes
OWNER VARCHAR2 (128) Yes
NAME VARCHAR2 (128) Yes
FROM_SCHEMA VARCHAR2 (128)
FROM_TYPE VARCHAR2 (128)
FROM_TOID RAW (16) Yes
FROM_VERSION NUMBER
Yes
TO_SCHEMA VARCHAR2 (128)
TO_TYPE VARCHAR2 (256)
TO_TOID RAW (16) Yes
TO_VERSION NUMBER
Yes
Query Text

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


SELECT TRANSFORMATION_ID
,      OWNER
,      NAME
,      FROM_SCHEMA
,      FROM_TYPE
,      FROM_TOID
,      FROM_VERSION
,      TO_SCHEMA
,      TO_TYPE
,      TO_TOID
,      TO_VERSION
FROM SYS.TRANSFORMATIONS$;

Dependencies

[top of page]

SYS.TRANSFORMATIONS$ does not reference any database object

SYS.TRANSFORMATIONS$ is referenced by following:

SchemaSYS
ViewALL_ATTRIBUTE_TRANSFORMATIONS
ViewALL_TRANSFORMATIONS
ViewDBA_ATTRIBUTE_TRANSFORMATIONS
ViewDBA_TRANSFORMATIONS
Package BodyDBMS_AQADM_SYS - show dependent code
Package BodyDBMS_AQJMS_INTERNAL - show dependent code
ViewKU$_QTRANS_VIEW
ViewUSER_ATTRIBUTE_TRANSFORMATIONS
ViewUSER_TRANSFORMATIONS