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
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
|
|
|