VIEW: SYS.DBA_SR_PARTN_OPS

Source

View Text - Preformatted

select u1.name owner,
       o1.name table_name,
       sts.partition_op,
       sts.partition_name,
       sts.outside_table_schema_name outside_table_schema,
       sts.outside_table_name outside_table_name
  from (sys.syncref$_objects s1 inner join sys.obj$ o1
         on o1.obj# = s1.obj# and o1.type# = s1.object_type_flag and o1.type# = 2
         and current_group_flag = 1 inner join sys.user$ u1
          on o1.owner# = u1.user#)
     inner join sys.syncref$_partn_ops  sts
      on  o1.obj# = sts.table_obj#

View Text - HTML Formatted

SELECT U1.NAME OWNER
, O1.NAME TABLE_NAME
, STS.PARTITION_OP
, STS.PARTITION_NAME
, STS.OUTSIDE_TABLE_SCHEMA_NAME OUTSIDE_TABLE_SCHEMA
, STS.OUTSIDE_TABLE_NAME OUTSIDE_TABLE_NAME
FROM (SYS.SYNCREF$_OBJECTS S1 INNER JOIN SYS.OBJ$ O1 ON O1.OBJ# = S1.OBJ#
AND O1.TYPE# = S1.OBJECT_TYPE_FLAG
AND O1.TYPE# = 2
AND CURRENT_GROUP_FLAG = 1 INNER JOIN SYS.USER$ U1 ON O1.OWNER# = U1.USER#) INNER JOIN SYS.SYNCREF$_PARTN_OPS STS ON O1.OBJ# = STS.TABLE_OBJ#