DBA Data[Home] [Help]

VIEW: SYS.HS_PARALLEL_SAMPLE_DATA

Source

View Text - Preformatted

select hs.dblink, hs.remote_table_name, hs.remote_schema_name, hs.low_value,
  hs.high_value, hs.position , hm.sample_column, hm.sample_column_type
from hs$_parallel_sample_data hs, HS$_PARALLEL_METADATA hm
  where hs.dblink = hm.dblink and hs.remote_table_name = hm.remote_table_name  and
       hs.remote_schema_name = hm.remote_schema_name 
View Text - HTML Formatted

SELECT HS.DBLINK
, HS.REMOTE_TABLE_NAME
, HS.REMOTE_SCHEMA_NAME
, HS.LOW_VALUE
, HS.HIGH_VALUE
, HS.POSITION
, HM.SAMPLE_COLUMN
, HM.SAMPLE_COLUMN_TYPE FROM HS$_PARALLEL_SAMPLE_DATA HS
, HS$_PARALLEL_METADATA HM
WHERE HS.DBLINK = HM.DBLINK
AND HS.REMOTE_TABLE_NAME = HM.REMOTE_TABLE_NAME AND HS.REMOTE_SCHEMA_NAME = HM.REMOTE_SCHEMA_NAME