SAP ABAP Class CL_ORA_PARTENGINE_GEN (Analyse Table and Creating Partition DDL)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
     ⤷ SDBO (Package) Database Administration: Oracle-Specific Components

Properties

Class	CL_ORA_PARTENGINE_GEN
Short Description	Analyse Table and Creating Partition DDL
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	SDBO	Database Administration: Oracle-Specific Components
Created	20081103	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ABAP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	ORAPR	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_ORA_PARTENGINE_GEN has no interface implemented.

Friends

Class CL_ORA_PARTENGINE_GEN has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	BAL_LOG_HANDLE	Instance attribute	Public	☑	Type reference (TYPE)	BALLOGHNDL			20090317
2	CREATSTAMP	Instance attribute	Private	☐	Type reference (TYPE)	SYSTTSTLO			20090317
3	CXTEXT	Static Attribute	Private	☐	Type reference (TYPE)	STRING			20090317
4	EMPTY_RANGES_NO	Instance attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20090317
5	ERROR_IN_RUN	Instance attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20090317
6	IT_PARTMD	Instance attribute	Public	☑	Type reference (TYPE)	ORAPR_T_PARTMD			20090317
7	IT_PARTNR	Instance attribute	Public	☑	Type reference (TYPE)	ORAPR_T_NR			20090317
8	IT_PARTSIZE	Instance attribute	Public	☑	Type reference (TYPE)	ORAPR_T_PARTSIZE			20090317
9	MINROWS_FOR_NEWDELTA	Constant	Public	☐	Type reference (TYPE)	I	10000		20090630
10	MINROWS_IN_CLIENT	Constant	Public	☐	Type reference (TYPE)	I	100000		20090317
11	MINROWS_IN_SUBOBJECT	Constant	Public	☐	Type reference (TYPE)	I	100000		20090317
12	MINROWS_IN_YEAR	Constant	Public	☐	Type reference (TYPE)	I	100000		20090317
13	NOCNT_PART	Instance attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20110113
14	NRMAP	Instance attribute	Private	☐	Type reference (TYPE)	NUMC2			20090317
15	ORAPART_TABLES_EXISTS	Instance attribute	Private	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20090317
16	PARTNR	Instance attribute	Public	☑	Type reference (TYPE)	ORAPR_S_NR			20090317
17	RESULTS_EXISTS	Instance attribute	Public	☑	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20090317
18	SUBMAP	Instance attribute	Private	☐	Type reference (TYPE)	NUM6			20090317
19	TSTMAP	Instance attribute	Private	☐	Type reference (TYPE)	STRING	'1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ_'		20090317
20	TSTMAPNR	Instance attribute	Private	☐	Type reference (TYPE)	STRING	'1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ !"#$%&''()*+,-./:;<>?@[]^_`{|}~'		20090317

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_MAXVALUE_CLIENT	Instance method	Private	Method	add final MAXVALUE client entry in partition schema	20090317
2	ADD_PARTITIONS_STORPAR	Instance method	Private	Method	fill partition entries in storpar	20090317
3	ADD_TEXT_LOG_MESSAGE	Instance method	Private	Method	add log message	20090317
4	ANALYSE_LAST_YEAR	Instance method	Private	Method	analyse rows last year	20090630
5	ANALYSIS_NR_EXTERN	Instance method	Private	Method	analysis table for nriv external numberrange	20090317
6	ANALYSIS_NR_INTERN	Instance method	Private	Method	analysis table for nriv internal numberrange	20090317
7	ANALYSIS_NR_INT_END	Instance method	Private	Method	handle end of anlysis	20090630
8	CALCULATE_NR_DATA_DBATAB	Instance method	Private	Method	Calculate maxrows, incrementby, spare from dba_* tables	20090317
9	CALCULATE_NR_DATA_INSPECT	Instance method	Private	Method	Calculate maxrows, incrementby, spare from collected data	20090317
10	CALCULATE_SPARE_PART	Instance method	Private	Method	calculate number of spare partitions	20090317
11	CHECK_IF_BATCH_RUNNING	Instance method	Private	Method	Check if batchjob is still running	20090317
12	CHECK_INPUT_DATA	Instance method	Private	Method	check input data	20090317
13	CHECK_NEEDED_INDEX	Instance method	Private	Method	check extra index	20090630
14	CHECK_NRIV	Instance method	Private	Method	check nriv entry	20090317
15	CHECK_NR_RANGES_EXTERN	Instance method	Private	Method	check external nriv data	20090317
16	CHECK_NR_RANGES_INTERN	Instance method	Private	Method	check internal nriv data	20090317
17	CHECK_ORAPART_TABLES	Static method	Public	Method	check if orapart tables exists	20090317
18	CHECK_REDEF_STATUS	Instance method	Private	Method	check if redefinition is running	20090317
19	CHECK_TABLE_CONSISTENCY	Instance method	Private	Method	check DDIC consistancy of table	20090317
20	CHECK_YEAR_INDEPEND_NR	Instance method	Private	Method	check year independent nr	20090715
21	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20090317
22	CREATE_DDL_PART_NRIV	Instance method	Private	Method	create table ddl for nriv partitioning	20090317
23	CREATE_WRP_ORAPARTGENDDL	Static method	Public	Method	create wrapper orapartgenddl view and function	20090317
24	CREATE_WRP_SORAMON	Static method	Public	Method	create wrapper soramon view and function	20090317
25	DELETE_OLD_LOG	Instance method	Private	Method	delete old application log	20090317
26	DELETE_OLD_RESULTS	Instance method	Private	Method	delete old results in tables	20090317
27	GET_AVG_PAGELG_INSPECT	Instance method	Private	Method	Calculate avg_row_len for LONG columns from collected data	20090630
28	GET_CURRENT_DELTA	Instance method	Private	Method	get current delta	20090317
29	GET_DBA_TAB_DATA	Instance method	Public	Method	get basic data from dba_tab* tables	20090317
30	GET_HIGHERCHAR	Instance method	Private	Method	get higher character	20090317
31	GET_LOWERCHAR	Instance method	Private	Method	get lower character	20090317
32	GET_NEW_INCREMENT	Instance method	Private	Method	Get new increment for analysis	20090630
33	GET_SECONDARY_INDEXES	Instance method	Private	Method	create ddl for secondary indexes	20090317
34	GET_SUBOBJECT_LIST	Instance method	Private	Method	get subobject list	20090317
35	HANDLE_NEW_CLIENT	Instance method	Private	Method	handle new value for client	20090317
36	HANDLE_SUBYEAR_SIMPLE	Instance method	Private	Method	handle subobject partitions without number ranges	20090630
37	INIT_PART	Instance method	Public	Method	initialize partition	20090317
38	INIT_PARTTYPE_NR	Instance method	Private	Method	initialize partition data for nriv partition method	20090317
39	INSERT_ORAPARTGENDDL	Instance method	Private	Method	insert DDL into orapartgenddl	20090317
40	INSERT_SORAMON	Instance method	Private	Method	insert DDL into soramon	20090317
41	MIGRATE_SORAMON_ENTRIES	Static method	Public	Method	migrate soramon entries	20090317
42	NOCNT_NRIV_OBJ	Instance method	Private	Method	Select nriv from object	20110113
43	PREPARE_START_GEN	Instance method	Private	Method	prepare start	20090317
44	READ_EXISTING_RESULTS	Instance method	Public	Method	Read existing results	20090317
45	READ_MASTER_DATA_NR	Static method	Public	Method	read built in nriv master data	20090317
46	RUN_INSPECT	Instance method	Public	Method	start batch run inspect	20090317
47	RUN_INSPECT_DIALOG	Instance method	Public	Method	run inspect in dialog	20090317
48	SEARCH_PREVIOUS_RESULTS	Instance method	Private	Method	Search for previous results	20090317
49	SELECT_NRIV_OBJ	Instance method	Private	Method	Select nriv from object	20090317
50	SELECT_NRIV_OBJ_SUB	Instance method	Private	Method	Select nriv from object subobject	20090317
51	SELECT_NRIV_OBJ_SUB_YEAR	Instance method	Private	Method	Select nriv from object subobject toyear	20090317
52	SELECT_NRIV_OBJ_YEAR	Instance method	Private	Method	Select nriv from object toyear	20090317
53	START_GEN_PART_NRIV	Instance method	Public	Method	Start nriv partition process	20090317
54	TABLE_ENTRIES_PER_CLIENT	Static method	Private	Method	entries per client in table	20090317
55	TOASCII	Instance method	Private	Method	char to ascii	20090317
56	WRITE_ERROR	Instance method	Private	Method	write error to log	20090317
57	WRITE_LOG_ITAB	Instance method	Private	Method	write log messages	20090630

Events

Class CL_ORA_PARTENGINE_GEN has no event.

Types

Class CL_ORA_PARTENGINE_GEN has no local type.

Method Signatures

Method ADD_MAXVALUE_CLIENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090317
2	Changing	PART_GESAMT	Call by reference	☐	Type reference (TYPE)	I			20090317
3	Importing	WA_NR_CLIENT	Call by reference	☐	Type reference (TYPE)	ORAPR_S_NR_CLIENT			20090317

Method ADD_MAXVALUE_CLIENT on class CL_ORA_PARTENGINE_GEN has no exception.

Method ADD_PARTITIONS_STORPAR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090317
2	Changing	IT_STORPAR	Call by reference	☐	Type reference (TYPE)	ORAPR_T_DDTEXTDATA			20090317

Method ADD_PARTITIONS_STORPAR on class CL_ORA_PARTENGINE_GEN has no exception.

Method ADD_TEXT_LOG_MESSAGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DETLEVEL	Call by reference	☐	Type reference (TYPE)	NUM1	'1'		20090317
2	Importing	I_LOG_MSG	Call by reference	☐	Type reference (TYPE)	CHAR200			20090317
3	Importing	I_MSGTYPE	Call by reference	☐	Type reference (TYPE)	SYMSGTY			20090317

Method ADD_TEXT_LOG_MESSAGE on class CL_ORA_PARTENGINE_GEN has no exception.

Method ANALYSE_LAST_YEAR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DETLEVEL	Call by reference	☐	Type reference (TYPE)	NUM1		Numeric 1-character	20090630
2	Returning	SKIP_NR	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090630
3	Importing	WA_NRIV	Call by reference	☐	Type reference (TYPE)	NRIV		Number Range Intervals	20090630

Method ANALYSE_LAST_YEAR on class CL_ORA_PARTENGINE_GEN has no exception.

Method ANALYSIS_NR_EXTERN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DETLEVEL	Call by reference	☐	Type reference (TYPE)	NUM1			20090317
2	Changing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090317
3	Exporting	PART_NR	Call by reference	☐	Type reference (TYPE)	I			20090317
4	Exporting	ROWS_GESAMT	Call by reference	☐	Type reference (TYPE)	ORADEC20			20090317
5	Importing	WA_NRIV	Call by reference	☐	Type reference (TYPE)	NRIV			20090317
6	Changing	WA_NR_CLIENT	Call by reference	☐	Type reference (TYPE)	ORAPR_S_NR_CLIENT			20090317
7	Importing	WA_SUBOBJECT	Call by reference	☑	Type reference (TYPE)	ORAPR_S_NRSOBJ			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method ANALYSIS_NR_INTERN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DETLEVEL	Call by reference	☐	Type reference (TYPE)	NUM1			20090317
2	Changing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090317
3	Exporting	PART_NR	Call by reference	☐	Type reference (TYPE)	I			20090317
4	Exporting	ROWS_GESAMT	Call by reference	☐	Type reference (TYPE)	ORADEC20			20090317
5	Importing	WA_NRIV	Call by reference	☐	Type reference (TYPE)	NRIV			20090317
6	Changing	WA_NR_CLIENT	Call by reference	☐	Type reference (TYPE)	ORAPR_S_NR_CLIENT			20090317
7	Importing	WA_SUBOBJECT	Call by reference	☑	Type reference (TYPE)	ORAPR_S_NRSOBJ			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method ANALYSIS_NR_INT_END Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DELTA	Call by reference	☐	Type reference (TYPE)	I			20090630
2	Importing	DETLEVELPLUS	Call by reference	☐	Type reference (TYPE)	NUM1		Numeric 1-character	20090630
3	Changing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090630
4	Changing	LAST_CNT	Call by reference	☐	Type reference (TYPE)	ORADEC20		DEC20 Field for Partition engine	20090630
5	Changing	LAST_RANGE	Call by reference	☐	Type reference (TYPE)	ORADEC20		DEC20 Field for Partition engine	20090630
6	Importing	MAXROWS	Call by reference	☐	Type reference (TYPE)	I			20090630
7	Exporting	NEWDELTA	Call by reference	☐	Type reference (TYPE)	I			20090630
8	Importing	PART_EXCEED	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20090630
9	Changing	PART_NR	Call by reference	☐	Type reference (TYPE)	I			20090630
10	Importing	ROWS_PART	Call by reference	☐	Type reference (TYPE)	I			20090630
11	Importing	WA_NRIV	Call by reference	☐	Type reference (TYPE)	NRIV		Number Range Intervals	20090630
12	Changing	WA_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_S_PART_NRIV			20090630

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐	General error in Partition Engine	20090630

Method CALCULATE_NR_DATA_DBATAB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CANCEL_FLAG	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090317

Method CALCULATE_NR_DATA_DBATAB on class CL_ORA_PARTENGINE_GEN has no exception.

Method CALCULATE_NR_DATA_INSPECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CANCEL_FLAG	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090317

Method CALCULATE_NR_DATA_INSPECT on class CL_ORA_PARTENGINE_GEN has no exception.

Method CALCULATE_SPARE_PART Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SPDATA	Call by reference	☐	Type reference (TYPE)	ORAPR_T_NR_SP			20090317
2	Importing	PART_NR	Call by reference	☐	Type reference (TYPE)	I			20090317
3	Returning	SPARE	Value transfer	☐	Type reference (TYPE)	I			20090317
4	Importing	WA_NRIV	Call by reference	☐	Type reference (TYPE)	NRIV			20090317

Method CALCULATE_SPARE_PART on class CL_ORA_PARTENGINE_GEN has no exception.

Method CHECK_IF_BATCH_RUNNING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RC	Value transfer	☐	Type reference (TYPE)	I			20090317

Method CHECK_IF_BATCH_RUNNING on class CL_ORA_PARTENGINE_GEN has no exception.

Method CHECK_INPUT_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CANCEL_FLAG	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090317
2	Importing	IT_DDFIELDS	Call by reference	☐	Type reference (TYPE)	ORAPR_T_DDFIELD			20090317

Method CHECK_INPUT_DATA on class CL_ORA_PARTENGINE_GEN has no exception.

Method CHECK_NEEDED_INDEX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CANCEL_FLAG	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090630
2	Importing	WA_PARTMD	Call by reference	☐	Type reference (TYPE)	ORAPR_S_PARTMD			20090630

Method CHECK_NEEDED_INDEX on class CL_ORA_PARTENGINE_GEN has no exception.

Method CHECK_NRIV Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	NRIV_ENTRIES_EXIST	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090317
2	Importing	WA_NR_CLIENT	Call by reference	☐	Type reference (TYPE)	ORAPR_S_NR_CLIENT			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method CHECK_NR_RANGES_EXTERN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	RC	Call by reference	☐	Type reference (TYPE)	I			20090317
2	Importing	WA_NRIV	Call by reference	☐	Type reference (TYPE)	NRIV			20090317

Method CHECK_NR_RANGES_EXTERN on class CL_ORA_PARTENGINE_GEN has no exception.

Method CHECK_NR_RANGES_INTERN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DETLEVEL	Call by reference	☐	Type reference (TYPE)	NUM1			20090317
2	Exporting	NUMBER_LENGTH	Call by reference	☐	Type reference (TYPE)	I			20090317
3	Exporting	RC	Call by reference	☐	Type reference (TYPE)	I			20090317
4	Importing	WA_NRIV	Call by reference	☐	Type reference (TYPE)	NRIV			20090317

Method CHECK_NR_RANGES_INTERN on class CL_ORA_PARTENGINE_GEN has no exception.

Method CHECK_ORAPART_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ORAPART_TABLES_EXISTS	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090317

Method CHECK_ORAPART_TABLES on class CL_ORA_PARTENGINE_GEN has no exception.

Method CHECK_REDEF_STATUS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CANCEL_FLAG	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090317
2	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	ORAPR_S_PARTMD-TABNAME			20090317

Method CHECK_REDEF_STATUS on class CL_ORA_PARTENGINE_GEN has no exception.

Method CHECK_TABLE_CONSISTENCY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	TABLE_INCONSISTANT	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090317
2	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	ORAPR_S_PARTMD-TABNAME			20090317

Method CHECK_TABLE_CONSISTENCY on class CL_ORA_PARTENGINE_GEN has no exception.

Method CHECK_YEAR_INDEPEND_NR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	CANCEL_FLAG	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090715
2	Exporting	CNT_EQ_9999	Value transfer	☐	Type reference (TYPE)	I			20090915
3	Exporting	CNT_NE_9999	Value transfer	☐	Type reference (TYPE)	I			20090915

Method CHECK_YEAR_INDEPEND_NR on class CL_ORA_PARTENGINE_GEN has no exception.

Method CONSTRUCTOR Signature

Method CONSTRUCTOR on class CL_ORA_PARTENGINE_GEN has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method CREATE_DDL_PART_NRIV Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090317
2	Importing	PART_GESAMT_TOT	Call by reference	☐	Type reference (TYPE)	I			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method CREATE_WRP_ORAPARTGENDDL Signature

Method CREATE_WRP_ORAPARTGENDDL on class CL_ORA_PARTENGINE_GEN has no parameter.
Method CREATE_WRP_ORAPARTGENDDL on class CL_ORA_PARTENGINE_GEN has no exception.

Method CREATE_WRP_SORAMON Signature

Method CREATE_WRP_SORAMON on class CL_ORA_PARTENGINE_GEN has no parameter.
Method CREATE_WRP_SORAMON on class CL_ORA_PARTENGINE_GEN has no exception.

Method DELETE_OLD_LOG Signature

Method DELETE_OLD_LOG on class CL_ORA_PARTENGINE_GEN has no parameter.
Method DELETE_OLD_LOG on class CL_ORA_PARTENGINE_GEN has no exception.

Method DELETE_OLD_RESULTS Signature

Method DELETE_OLD_RESULTS on class CL_ORA_PARTENGINE_GEN has no parameter.
Method DELETE_OLD_RESULTS on class CL_ORA_PARTENGINE_GEN has no exception.

Method GET_AVG_PAGELG_INSPECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	AVG_PAGELN	Value transfer	☐	Type reference (TYPE)	I			20090630

Method GET_AVG_PAGELG_INSPECT on class CL_ORA_PARTENGINE_GEN has no exception.

Method GET_CURRENT_DELTA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	DELTA	Value transfer	☐	Type reference (TYPE)	I			20090317
2	Importing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090317
3	Importing	MAXROWS	Call by reference	☐	Type reference (TYPE)	I			20090317
4	Importing	PART_NR	Call by reference	☐	Type reference (TYPE)	I			20090317
5	Importing	WA_NRIV	Call by reference	☐	Type reference (TYPE)	NRIV			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method GET_DBA_TAB_DATA Signature

Method GET_DBA_TAB_DATA on class CL_ORA_PARTENGINE_GEN has no parameter.
Method GET_DBA_TAB_DATA on class CL_ORA_PARTENGINE_GEN has no exception.

Method GET_HIGHERCHAR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CHANGED_CHAR	Value transfer	☐	Type reference (TYPE)	CHAR1			20090317
2	Importing	CHAR_TO_CHANGE	Call by reference	☐	Type reference (TYPE)	CHAR1			20090317

Method GET_HIGHERCHAR on class CL_ORA_PARTENGINE_GEN has no exception.

Method GET_LOWERCHAR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CHANGED_CHAR	Value transfer	☐	Type reference (TYPE)	CHAR1			20090317
2	Importing	CHAR_TO_CHANGE	Call by reference	☐	Type reference (TYPE)	CHAR1			20090317

Method GET_LOWERCHAR on class CL_ORA_PARTENGINE_GEN has no exception.

Method GET_NEW_INCREMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CNT_ROWS	Call by reference	☐	Type reference (TYPE)	I			20090630
2	Importing	MAXROWS	Call by reference	☐	Type reference (TYPE)	I			20090630
3	Returning	NEWINCREMENTBY	Value transfer	☐	Type reference (TYPE)	I			20090630
4	Importing	WA_NRIV	Call by reference	☐	Type reference (TYPE)	NRIV		Number Range Intervals	20090630
5	Importing	WHERE_CLAUSE	Call by reference	☐	Type reference (TYPE)	STRING			20090630

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐	General error in Partition Engine	20090630

Method GET_SECONDARY_INDEXES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	IT_STMTS	Call by reference	☐	Type reference (TYPE)	ORAPR_T_STMTS			20090317
2	Importing	OWNER_TABQUOTED_NEW	Call by reference	☐	Type reference (TYPE)	ORAPR_TABQUOTED			20090317
3	Importing	PART_GESAMT_TOT	Call by reference	☐	Type reference (TYPE)	I			20090317
4	Importing	TABQUOTED	Call by reference	☐	Type reference (TYPE)	ORAPR_TABQUOTED			20090317
5	Importing	TABSPACE_NOT_QUOTED	Call by reference	☐	Type reference (TYPE)	ORAPR_TABQUOTED			20090317
6	Importing	TABSPACE_QUOTED	Call by reference	☐	Type reference (TYPE)	ORAPR_TABQUOTED			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method GET_SUBOBJECT_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	IT_SUBOBJECT	Value transfer	☐	Type reference (TYPE)	ORAPR_T_NRSOBJ			20090317
2	Importing	WA_NR_CLIENT	Call by reference	☐	Type reference (TYPE)	ORAPR_S_NR_CLIENT			20090317

Method GET_SUBOBJECT_LIST on class CL_ORA_PARTENGINE_GEN has no exception.

Method HANDLE_NEW_CLIENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CLIENTN	Value transfer	☐	Type reference (TYPE)	NUMC3			20090317
2	Importing	CLIENTN_BEFORE	Value transfer	☐	Type reference (TYPE)	NUMC3			20090317
3	Changing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090317
4	Changing	PART_GESAMT_TOT	Call by reference	☐	Type reference (TYPE)	I			20090317

Method HANDLE_NEW_CLIENT on class CL_ORA_PARTENGINE_GEN has no exception.

Method HANDLE_SUBYEAR_SIMPLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CLIENT	Call by reference	☐	Type reference (TYPE)	MANDT		Client	20090630
2	Importing	CL_MAXROWS	Call by reference	☐	Type reference (TYPE)	I			20090715
3	Changing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090630
4	Exporting	PART_NR	Call by reference	☐	Type reference (TYPE)	I			20090630
5	Importing	WA_SUBOBJECT	Call by reference	☐	Type reference (TYPE)	ORAPR_S_NRSOBJ			20090630

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐	General error in Partition Engine	20090630

Method INIT_PART Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	CANCEL_FLAG	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20090317
2	Importing	INCREMENT_FACTOR	Call by reference	☑	Type reference (TYPE)	ORAPR_S_NR-INCREMENT_FACTOR			20101210
3	Exporting	IT_CLIENT_ALV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_CLIENT_ALV			20090317
4	Importing	ONLY_BASIC_DATA	Call by reference	☑	Type reference (TYPE)	FLAG			20090317
5	Importing	PARTSIZE_VALUE	Call by reference	☑	Type reference (TYPE)	ORAPR_S_NR-PARTSIZE			20090317
6	Importing	WA_PARTMD	Call by reference	☐	Type reference (TYPE)	ORAPR_S_PARTMD			20090317

Method INIT_PART on class CL_ORA_PARTENGINE_GEN has no exception.

Method INIT_PARTTYPE_NR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	CANCEL_FLAG	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20090317
2	Importing	INCREMENT_FACTOR	Call by reference	☑	Type reference (TYPE)	ORAPR_S_NR-INCREMENT_FACTOR			20101210
3	Exporting	IT_CLIENT_ALV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_CLIENT_ALV			20090317
4	Importing	ONLY_BASIC_DATA	Call by reference	☑	Type reference (TYPE)	FLAG			20090317
5	Importing	PARTSIZE_VALUE	Call by reference	☑	Type reference (TYPE)	ORAPR_S_NR-PARTSIZE			20090317
6	Importing	WA_PARTMD	Call by reference	☐	Type reference (TYPE)	ORAPR_S_PARTMD			20090317

Method INIT_PARTTYPE_NR on class CL_ORA_PARTENGINE_GEN has no exception.

Method INSERT_ORAPARTGENDDL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_STMTS	Call by reference	☐	Type reference (TYPE)	ORAPR_T_STMTS			20090317
2	Returning	RC	Value transfer	☐	Type reference (TYPE)	I			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method INSERT_SORAMON Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_STMTS	Call by reference	☐	Type reference (TYPE)	ORAPR_T_STMTS			20090317
2	Returning	RC	Value transfer	☐	Type reference (TYPE)	I			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method MIGRATE_SORAMON_ENTRIES Signature

Method MIGRATE_SORAMON_ENTRIES on class CL_ORA_PARTENGINE_GEN has no parameter.
Method MIGRATE_SORAMON_ENTRIES on class CL_ORA_PARTENGINE_GEN has no exception.

Method NOCNT_NRIV_OBJ Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20110113
2	Exporting	PART_GESAMT	Call by reference	☐	Type reference (TYPE)	I			20110113
3	Exporting	ROWS_GESAMT	Call by reference	☐	Type reference (TYPE)	ORADEC20			20110113
4	Changing	WA_NR_CLIENT	Call by reference	☐	Type reference (TYPE)	ORAPR_S_NR_CLIENT			20110113

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20110113

Method PREPARE_START_GEN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CANCEL_FLAG	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090317

Method PREPARE_START_GEN on class CL_ORA_PARTENGINE_GEN has no exception.

Method READ_EXISTING_RESULTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_IT_DDL	Call by reference	☐	Type reference (TYPE)	ORAPR_T_LINE			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method READ_MASTER_DATA_NR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	IT_PARTNR	Call by reference	☐	Type reference (TYPE)	ORAPR_T_NR			20090317

Method READ_MASTER_DATA_NR on class CL_ORA_PARTENGINE_GEN has no exception.

Method RUN_INSPECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RC	Value transfer	☐	Type reference (TYPE)	I			20090317
2	Importing	SDLSTRTDT	Call by reference	☑	Type reference (TYPE)	TBTCJOB-SDLSTRTDT			20090317
3	Importing	SDLSTRTTM	Call by reference	☑	Type reference (TYPE)	TBTCJOB-SDLSTRTTM			20090317

Method RUN_INSPECT on class CL_ORA_PARTENGINE_GEN has no exception.

Method RUN_INSPECT_DIALOG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CANCEL_FLAG	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090317

Method RUN_INSPECT_DIALOG on class CL_ORA_PARTENGINE_GEN has no exception.

Method SEARCH_PREVIOUS_RESULTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table Name	20090715

Method SEARCH_PREVIOUS_RESULTS on class CL_ORA_PARTENGINE_GEN has no exception.

Method SELECT_NRIV_OBJ Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090317
2	Exporting	PART_GESAMT	Call by reference	☐	Type reference (TYPE)	I			20090317
3	Exporting	ROWS_GESAMT	Call by reference	☐	Type reference (TYPE)	ORADEC20			20090317
4	Changing	WA_NR_CLIENT	Call by reference	☐	Type reference (TYPE)	ORAPR_S_NR_CLIENT			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method SELECT_NRIV_OBJ_SUB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090317
2	Exporting	PART_GESAMT	Call by reference	☐	Type reference (TYPE)	I			20090317
3	Exporting	ROWS_GESAMT	Call by reference	☐	Type reference (TYPE)	ORADEC20			20090317
4	Changing	WA_NR_CLIENT	Call by reference	☐	Type reference (TYPE)	ORAPR_S_NR_CLIENT			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method SELECT_NRIV_OBJ_SUB_YEAR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090317
2	Exporting	PART_GESAMT	Call by reference	☐	Type reference (TYPE)	I			20090317
3	Exporting	ROWS_GESAMT	Call by reference	☐	Type reference (TYPE)	ORADEC20			20090317
4	Changing	WA_NR_CLIENT	Call by reference	☐	Type reference (TYPE)	ORAPR_S_NR_CLIENT			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method SELECT_NRIV_OBJ_YEAR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	IT_PART_NRIV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_PART_NRIV			20090317
2	Exporting	PART_GESAMT	Call by reference	☐	Type reference (TYPE)	I			20090317
3	Exporting	ROWS_GESAMT	Call by reference	☐	Type reference (TYPE)	ORADEC20			20090317
4	Changing	WA_NR_CLIENT	Call by reference	☐	Type reference (TYPE)	ORAPR_S_NR_CLIENT			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method START_GEN_PART_NRIV Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	EMPTY_RANGES	Call by reference	☑	Type reference (TYPE)	FLAG			20090317
2	Exporting	E_CANCEL_FLAG	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20090317
3	Importing	I_IT_CLIENT_ALV	Call by reference	☐	Type reference (TYPE)	ORAPR_T_CLIENT_ALV			20090317
4	Importing	NOCNT_PART	Call by reference	☑	Type reference (TYPE)	FLAG		General Flag	20110113

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method TABLE_ENTRIES_PER_CLIENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CLIENTCOLUMN	Call by reference	☐	Type reference (TYPE)	FIELDNAME			20090317
2	Returning	IT_CLIENT_ALV	Value transfer	☐	Type reference (TYPE)	ORAPR_T_CLIENT_ALV			20090317
3	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME			20090317

Method TABLE_ENTRIES_PER_CLIENT on class CL_ORA_PARTENGINE_GEN has no exception.

Method TOASCII Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ASCIIVALUE	Value transfer	☐	Type reference (TYPE)	CHAR2			20090317
2	Importing	CHARTOCHANGE	Call by reference	☐	Type reference (TYPE)	CHAR1			20090317

Method TOASCII on class CL_ORA_PARTENGINE_GEN has no exception.

Method WRITE_ERROR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DETLEVEL	Call by reference	☐	Type reference (TYPE)	NUM1	'1'		20090317
2	Importing	WA_NRIV	Call by reference	☑	Type reference (TYPE)	NRIV			20090317

#	Exception	Resumable	Description	Created on
1	CX_ORA_PARTENGINE_PROG_ERROR	☐		20090317

Method WRITE_LOG_ITAB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_LOG_MSG	Call by reference	☐	Type reference (TYPE)	ORAPR_T_LOG_MSG			20090630

Method WRITE_LOG_ITAB on class CL_ORA_PARTENGINE_GEN has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	703