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

VIEW: SYS.CDB_REDEFINITION_STATUS

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

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
REDEFINITION_ID NUMBER
Yes Redefinition ID for this 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
BASE_PARTITION_NAME VARCHAR2 (128) Yes Name of the base partition of the redefinition object
INTERIM_OBJECT_OWNER VARCHAR2 (128)
Owner of the interim object of the redefinition object
INTERIM_OBJECT_NAME VARCHAR2 (128)
Name of the interim object of the redefinition object
OPERATION VARCHAR2 (128) Yes The current operation
STATUS VARCHAR2 (128) Yes Status of the previous operation
RESTARTABLE VARCHAR2 (1) Yes The restartability of the previous operation
CON_ID NUMBER

container id
Query Text

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


SELECT REDEFINITION_ID
,      BASE_TABLE_OWNER
,      BASE_TABLE_NAME
,      BASE_PARTITION_NAME
,      INTERIM_OBJECT_OWNER
,      INTERIM_OBJECT_NAME
,      OPERATION
,      STATUS
,      RESTARTABLE
,      CON_ID
FROM SYS.CDB_REDEFINITION_STATUS;

Dependencies

[top of page]

SYS.CDB_REDEFINITION_STATUS does not reference any database object

SYS.CDB_REDEFINITION_STATUS is referenced by following:

SchemaPUBLIC
SynonymCDB_REDEFINITION_STATUS