1 PACKAGE DBMS_HS_PARALLEL authid current_user as
2 no_dblink exception;
3 no_remote_table exception;
4 no_view exception;
5 pragma exception_init(no_dblink, -24277);
6 pragma exception_init(no_remote_table, -24278);
7 pragma exception_init(no_view, -24279);
8 no_dblink_num number := -24277;
9 no_remote_table_num number := -24278;
10 no_view_num number := -24279;
11 type hs_part_rec is record (t hs_partition_obj);
12 type hs_partion_rec is record (t hs_part_obj);
13 type hs_sample_rec is record (t hs_sample_obj);
14 type hs_part_refcur_t is ref cursor return hs_part_rec;
15 type hs_partion_refcur_t is ref cursor return hs_partion_rec;
16 type hs_sample_refcur_t is ref cursor return hs_sample_rec;
17
18 procedure LOAD_TABLE(remote_table in varchar2 ,
19 database_link in varchar2 ,
20 oracle_table in varchar2 := null, truncate in boolean := true,
21 parallel_degree in integer := null, row_count out number) ;
22 procedure CREATE_OR_REPLACE_VIEW(remote_table in varchar2 ,
23 database_link in varchar2 ,
24 oracle_view in varchar2 := null, parallel_degree in integer := null ) ;
25 procedure DROP_VIEW(oracle_view in varchar2);
26 procedure CREATE_TABLE_TEMPLATE (remote_table in varchar2, database_link in varchar2,
27 oracle_table in varchar2 := null, create_table_template_string out varchar2);
28
29 end DBMS_HS_PARALLEL;