Edit D:\app\Administrator\product\11.2.0\dbhome_1\ctx\admin\driimp.pkh
Rem Copyright (c) 1998, 2007, Oracle. All rights reserved. Rem NAME Rem driimp.pkh Rem DESCRIPTION Rem import utility functions. Rem RETURNS Rem Rem NOTES Rem Rem MODIFIED (MM/DD/YY) Rem wclin 02/22/07 - bug 5894098: impdp/expdp of CDI Rem yucheng 07/22/03 - fix lrg 1546655 Rem yucheng 05/23/03 - handle sync attributes Rem gkaminag 03/05/01 - handle pending for transportable tablespace Rem yucheng 12/20/00 - transport partition support Rem yucheng 12/12/00 - partition support Rem gkaminag 03/07/00 - handle index type column Rem gkaminag 06/21/99 - format and charset columns Rem gkaminag 06/09/99 - handle language column Rem gkaminag 06/07/99 - multi lexer Rem ehuang 05/11/98 - creation create or replace package driimp as /*-------------------------- create_index ---------------------------*/ /* NAME create_index DESCRIPTION insert into dr$index during import. ARGUMENTS columns to dr$index, except id, owner and status. NOTES EXCEPTIONS RETURNS */ PROCEDURE create_index( p_idx_name IN varchar2, p_idx_table IN varchar2, p_idx_table_owner IN varchar2, p_idx_key_name IN varchar2, p_idx_key_type IN varchar2, p_idx_text_name IN varchar2, p_idx_text_type IN varchar2, p_idx_text_length IN varchar2, p_idx_docid_count IN varchar2, p_idx_version IN varchar2, p_idx_nextid IN varchar2, p_idx_langcol in varchar2 default null, p_idx_fmtcol in varchar2 default null, p_idx_csetcol in varchar2 default null, p_idx_type in number default 0, P_idx_option in varchar2 default null, p_idx_sync_type in varchar2 default null, p_idx_sync_memory in varchar2 default null, p_idx_sync_para_degree in number default null, p_idx_sync_interval in varchar2 default null ); /*-------------------------- create_partition ----------------------*/ /* NAME create_partition DESCRIPTION insert into dr$index_partition during import. ARGUMENTS p_ixp_id : partition ID p_ixp_name: partition name NOTES EXCEPTIONS RETURNS */ PROCEDURE create_partition( p_ixp_id IN number, p_ixp_name IN varchar2, p_ixp_docid_count IN number, p_ixp_nextid IN number, p_ixp_opt_token IN VARCHAR2, p_ixp_opt_type IN number, p_ixp_opt_count IN number, p_ixp_sync_type IN VARCHAR2 default null, p_ixp_sync_memory IN VARCHAR2 default null, p_ixp_sync_para_degree IN NUMBER default null, p_ixp_sync_interval IN VARCHAR2 default null ); /*-------------------------- set_object ---------------------------*/ /* NAME set_object DESCRIPTION insert into dr$index_object for this class_name and object_name ARGUMENTS p_cla_name (IN) - class name p_obj_name (IN) - object name p_acnt (IN) - number of attributes NOTES EXCEPTIONS RETURNS */ PROCEDURE set_object( p_cla_name IN varchar2, p_obj_name IN varchar2, p_acnt IN varchar2 ); /*-------------------------- set_value ----------------------------*/ /* NAME set_value DESCRIPTION insert into dr$index_value ARGUMENTS p_att_name (IN) - attribute name p_att_value (IN) - attribute value NOTES EXCEPTIONS RETURNS */ PROCEDURE set_value( p_att_name IN varchar2, p_att_value IN varchar2 ); /*-------------------------- set_sub_value ----------------------------*/ /* NAME set_sub_value DESCRIPTION insert into dr$index_value ARGUMENTS p_att_name (IN) - attribute name p_att_value (IN) - attribute value NOTES EXCEPTIONS RETURNS */ PROCEDURE set_sub_value( p_att_name IN varchar2, p_sub_group IN number, p_sub_obj IN varchar2, p_sub_att IN varchar2, p_sub_value IN varchar2 ); /*-------------------------- add_pending ----------------------------*/ /* NAME add_pending DESCRIPTION insert into dr$pending ARGUMENTS p_pid (IN) - partition id p_rowid (IN) - rowid NOTES EXCEPTIONS RETURNS */ PROCEDURE add_pending( p_pid IN number, p_rowid IN rowid ); /*-------------------------- add_cdicol ----------------------------*/ /* NAME add_cdicol DESCRIPTION insert into dr$index_cdi_column ARGUMENTS columns to dr$index_cdi_column, except id NOTES EXCEPTIONS RETURNS */ PROCEDURE add_cdicol( p_cdi_column_position IN number, p_cdi_column_name IN varchar2, p_cdi_column_type IN varchar2, p_cdi_column_type# IN number, p_cdi_column_length IN number, p_cdi_section_name IN varchar2, p_cdi_section_type IN number, p_cdi_section_id IN number, p_cdi_sort_order IN varchar2 ); end driimp; /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de