[Home] [Help] [Dependency Information]

TABLE: SYS.HS$_PARALLEL_METADATA

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: HS_PARALLEL_METADATA_PK

1. DBLINK
2. REMOTE_TABLE_NAME
3. REMOTE_SCHEMA_NAME

Unique Key: SYS_C00235345

1. SYS_NC0001900020$

Unique Key: SYS_C00235346

1. SYS_NC0001700018$

Indexes

Index	Type	Uniqueness	Tablespace	Column
HS_PARALLEL_METADATA_PK	NORMAL	UNIQUE	SYSTEM	DBLINK REMOTE_TABLE_NAME REMOTE_SCHEMA_NAME
SYS_C00235345	NORMAL	UNIQUE	SYSTEM	PARTITION_COL_TYPES
SYS_C00235346	NORMAL	UNIQUE	SYSTEM	PARTITION_COL_NAMES

Foreign Keys

Table		Foreign Table	Foreign Key Column
HS$_PARALLEL_HISTOGRAM_DATA		HS$_PARALLEL_METADATA	HS$_PARALLEL_HISTOGRAM_DATA DBLINK HS$_PARALLEL_HISTOGRAM_DATA REMOTE_TABLE_NAME HS$_PARALLEL_HISTOGRAM_DATA REMOTE_SCHEMA_NAME
HS$_PARALLEL_PARTITION_DATA		HS$_PARALLEL_METADATA	HS$_PARALLEL_PARTITION_DATA DBLINK HS$_PARALLEL_PARTITION_DATA REMOTE_TABLE_NAME HS$_PARALLEL_PARTITION_DATA REMOTE_SCHEMA_NAME
HS$_PARALLEL_SAMPLE_DATA		HS$_PARALLEL_METADATA	HS$_PARALLEL_SAMPLE_DATA DBLINK HS$_PARALLEL_SAMPLE_DATA REMOTE_TABLE_NAME HS$_PARALLEL_SAMPLE_DATA REMOTE_SCHEMA_NAME

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT DBLINK
,      REMOTE_TABLE_NAME
,      REMOTE_SCHEMA_NAME
,      PARALLEL
,      PARALLEL_DEGREE
,      RANGE_PARTITIONED
,      SAMPLED
,      HISTOGRAM
,      IND_AVAILABLE
,      SAMPLE_CAP
,      HIST_COLUMN
,      HIST_COLUMN_TYPE
,      SAMPLE_COLUMN
,      SAMPLE_COLUMN_TYPE
,      NUM_PARTITIONS
,      NUM_PARTITION_COLUMNS
,      PARTITION_COL_NAMES
,      PARTITION_COL_TYPES
,      NCOL_MIN_VAL
,      NCOL_AVG_VAL
,      NCOL_MAX_VAL
,      NUM_BUCKETS
FROM SYS.HS$_PARALLEL_METADATA;

Dependencies

[top of page]

SYS

HSBLKNAMLST

STANDARD - show dependent code

SYS

HS_PARALLEL_METADATA

HS_PARALLEL_PARTITION_DATA

HS_PARALLEL_SAMPLE_DATA