PACKAGE: SYS.DBMS_HS_PARALLEL_METADATA

Source

1 PACKAGE dbms_hs_parallel_metadata  as
2   type HvList is table of varchar2(5000);
3   type NumList is table of number;
4   function check_cap(dblink in varchar2, cap_number in number) return boolean;
5   function get_cpu_num return integer;
6   function get_domain_name return varchar2;
7   procedure  raise_system_error(error_number IN INTEGER, arg1  IN VARCHAR2);
8   procedure  loadIndColinfo (remote_schema in varchar2,
9   remote_table_name in varchar2, dblink in varchar2,
10   ind_available in boolean, max_val in number , min_val in number,
11    avg_val in number, part_column in varchar2 , part_col_type in varchar2 ,
12    p_col_names in HSBLKNamLst, p_col_types in HSBLKNamLst ,
13    col_names in HSBLKNamLst, col_types in HSBLKNamLst,
14   parallel_degree in integer);
15   procedure  loadHisinfo (remote_schema in varchar2,
16   remote_table_name in varchar2, dblink in varchar2,
17   ind_available in boolean, numBucket in number , part_column in varchar2 ,
18     part_col_type in varchar2 , p_col_names in HSBLKNamLst,
19     p_col_types in HSBLKNamLst , hisValues in NumList,
20    col_names in HSBLKNamLst, col_types in HSBLKNamLst,
21    parallel_degree in integer);
22   procedure  loadPatitioninfo (remote_schema in varchar2,
23    remote_table_name in varchar2, dblink in varchar2,
24    p_cnt in number, p_key_cols in HSBLKNamLst, p_key_cnt in  number,
25    typlst in HSBLKNamLst,hvalueList in HvList,
26    hvalLen in  NumList, partPos  in NumList ,
27    parallel_degree in integer);
28   procedure  purgemetadata(remote_schema in varchar2, remote_table_name
29   in varchar2, dblink in varchar2 );
30 
31   procedure update_samplemeta(remote_schema in varchar2, remote_table_name
32   in varchar2, dblink in varchar2 ,parallel_degree in integer,
33  sample_column in varchar2, sample_column_type in varchar2);
34   procedure load_sampledata(remote_schema in varchar2, remote_table_name
35   in varchar2, dblink in varchar2 , low_value in varchar2,
36   high_value in varchar2, position in integer);
37 
38 
39   procedure  insert_viewobj( ora_view_schema in varchar2, oraview_name
40   in varchar2, hsbkseq in number);
41 
42   procedure  delete_viewobj( ora_view_schema in varchar2, ora_view_name
43   in varchar2);
44 
45 
46   procedure table_sampling( remote_schema in varchar2,
47       remote_table_name in varchar2, database_link in varchar2,
48        hs_remote_tab_typ in varchar2,  p_degree in number,
49       row_count in number,  ora_user in varchar2, oracle_table_name  in varchar2,
50        pt_col_names in HSBLKNamLst , pt_col_types in  HSBLKNamLst ,
51        col_names in  HSBLKNamLst , col_types in  HSBLKNamLst) ;
52   procedure schedule_sampling (remote_schema in varchar2,
53       remote_table_name in varchar2, database_link in varchar2,
54        hs_remote_tab_typ in varchar2, p_degree in integer,
55       row_count in number, ora_user in varchar2, oracle_table_name  in varchar2,
56       pt_col_names in HSBLKNamLst , pt_col_types in  HSBLKNamLst ,
57       col_names in  HSBLKNamLst , col_types in  HSBLKNamLst);
58 
59 
60 end dbms_hs_parallel_metadata;