eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS.HS_PARALLEL_PARTITION_DATA

Source

View Text - Preformatted


select hp.dblink, hp.remote_table_name, hp.remote_schema_name, hp.low_value,
  hp.high_value, hp.partition_position , hm.partition_col_names,
 hm.partition_col_types
from hs$_parallel_partition_data hp, HS$_PARALLEL_METADATA hm
  where hp.dblink = hm.dblink and hp.remote_table_name = hm.remote_table_name
   and hp.remote_schema_name = hm.remote_schema_name

View Text - HTML Formatted

SELECT HP.DBLINK
, HP.REMOTE_TABLE_NAME
, HP.REMOTE_SCHEMA_NAME
, HP.LOW_VALUE
, HP.HIGH_VALUE
, HP.PARTITION_POSITION
, HM.PARTITION_COL_NAMES
, HM.PARTITION_COL_TYPES FROM HS$_PARALLEL_PARTITION_DATA HP
, HS$_PARALLEL_METADATA HM
WHERE HP.DBLINK = HM.DBLINK
AND HP.REMOTE_TABLE_NAME = HM.REMOTE_TABLE_NAME
AND HP.REMOTE_SCHEMA_NAME = HM.REMOTE_SCHEMA_NAME