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

VIEW: SYS.DBA_REDEFINITION_OBJECTS

Object Details
Object Name: DBA_REDEFINITION_OBJECTS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
OBJECT_TYPE VARCHAR2 (12)
Type of the redefinition object
OBJECT_OWNER VARCHAR2 (4000)
Owner of the redefinition object
OBJECT_NAME VARCHAR2 (128) Yes Name of the redefinition object
BASE_TABLE_OWNER VARCHAR2 (128)
Owner of the base table of the redefinition object
BASE_TABLE_NAME VARCHAR2 (128)
Name of the base table of the redefinition object
INTERIM_OBJECT_OWNER VARCHAR2 (4000)
Owner of the corresponding interim redefinition object
INTERIM_OBJECT_NAME VARCHAR2 (128)
Name of the corresponding interim redefinition object
EDITION_NAME VARCHAR2 (128)
Name of the edition that the redefinition object belongs to
Query Text

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


SELECT OBJECT_TYPE
,      OBJECT_OWNER
,      OBJECT_NAME
,      BASE_TABLE_OWNER
,      BASE_TABLE_NAME
,      INTERIM_OBJECT_OWNER
,      INTERIM_OBJECT_NAME
,      EDITION_NAME
FROM SYS.DBA_REDEFINITION_OBJECTS;

Dependencies

[top of page]

SYS.DBA_REDEFINITION_OBJECTS references the following:

SchemaSYS
TableOBJ$
TableREDEF_OBJECT$
TableUSER$
SYS.DBA_REDEFINITION_OBJECTS is referenced by following:

SchemaPUBLIC
SynonymDBA_REDEFINITION_OBJECTS
SchemaSYS
PL/SQL PackageDBMS_REDEFINITION_INTERNAL - show dependent code