DBA Data[Home] [Help]

VIEW: SYS.KU$_TTS_TAB_TABLESPACE_VIEW

Source

View Text - Preformatted

SELECT "OBJ_NUM","PARTOBJ","TS_NAME","TS_NUM" FROM ku$_tts_tabview
  UNION ALL
    SELECT "OBJ_NUM","PARTOBJ","TS_NAME","TS_NUM" FROM ku$_tts_tabpartview
  UNION ALL
    SELECT "OBJ_NUM","PARTOBJ","TS_NAME","TS_NUM" FROM ku$_tts_tabsubpartview
  UNION ALL
    SELECT "OBJ_NUM","PARTOBJ","TS_NAME","TS_NUM" FROM ku$_tts_partlobview
  UNION ALL
    SELECT "OBJ_NUM","PARTOBJ","TS_NAME","TS_NUM" FROM ku$_tts_subpartlobview
View Text - HTML Formatted

SELECT "OBJ_NUM"
, "PARTOBJ"
, "TS_NAME"
, "TS_NUM"
FROM KU$_TTS_TABVIEW UNION ALL SELECT "OBJ_NUM"
, "PARTOBJ"
, "TS_NAME"
, "TS_NUM"
FROM KU$_TTS_TABPARTVIEW UNION ALL SELECT "OBJ_NUM"
, "PARTOBJ"
, "TS_NAME"
, "TS_NUM"
FROM KU$_TTS_TABSUBPARTVIEW UNION ALL SELECT "OBJ_NUM"
, "PARTOBJ"
, "TS_NAME"
, "TS_NUM"
FROM KU$_TTS_PARTLOBVIEW UNION ALL SELECT "OBJ_NUM"
, "PARTOBJ"
, "TS_NAME"
, "TS_NUM"
FROM KU$_TTS_SUBPARTLOBVIEW