SAP ABAP Class CL_ORA_PARTENGINE_ADMIN (Partengine Admin: Adding/Merging partitions)
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_ADMIN  
Short Description Partengine Admin: Adding/Merging partitions    
Super Class    
Instantiability of a Class 2  Public 
Final    
General Data
Message Class Q2    
Program status P  SAP Standard Production Program 
Category 0   
Package SDBO   Database Administration: Oracle-Specific Components 
Created 20081103   SAP 
Last change 20110908   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 ORAPR Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
Class CL_ORA_PARTENGINE_ADMIN has no interface implemented.
Friends
Class CL_ORA_PARTENGINE_ADMIN has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 CXTEXT Static Attribute Private Type reference (TYPE) STRING 20090317
2 C_PRODUCTIVE Constant Public Type reference (TYPE) ORAPR_S_PARTADM_ALV-ADDPART 'Productive' 20090317
3 C_TESTMODE Constant Public Type reference (TYPE) ORAPR_S_PARTADM_ALV-ADDPART 'Testmode' 20090317
4 IT_ADMIN_DATA Instance attribute Private Type reference (TYPE) ORAPR_T_ADMIN 20090317
5 LOG_LEVEL Instance attribute Private Type reference (TYPE) I 0 20100419
6 MAX_ROWS_EXCLUDE Instance attribute Private Type reference (TYPE) I 1000000 20090317
7 MAX_ROWS_MERGE Instance attribute Private Type reference (TYPE) I 5000 20090317
8 OWNER Instance attribute Private Type reference (TYPE) FIELDNAME 20090317
9 PARALLEL_C Instance attribute Private Type reference (TYPE) CHAR3 '4' 20090317
10 SINGLE_TABLE Instance attribute Private Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20090317
Methods
# Method Level Visibility Method type Description Created on
1 ADD_BASE_DATA Instance method Private Method add base data 20090317
2 ASCIITOCHAR Static method Private Method ascii code to char 20090317
3 CONSTRUCTOR Instance method Public Constructor CONSTRUCTOR 20090317
4 CREATE_MERGE_ENTRY Instance method Private Method create data for partition merge 20090317
5 CREATE_NEWPART_ENTRY Instance method Private Method create data for partition split 20090317
6 CREA_PART_STATISTICS Instance method Private Method create statistics for partition 20090317
7 DISPLAY_JOBS Static method Public Method Display Jobs 20090317
8 GET_ADM_DATA Instance method Private Method get admin data 20090317
9 GET_HIGHERCHAR Instance method Private Method get higher character 20090317
10 GET_LOWERCHAR Instance method Private Method get lower character 20090630
11 GET_MAXNRVALUE_IN_PART Instance method Private Method get max nr value in partition 20090317
12 GET_NR_FROM_TONUMBER Instance method Private Method get number range from tonumber 20090317
13 GET_PARTADM_LIST Static method Public Method get list of partengine administrated tables 20090317
14 GET_PARTITIONS_NR Instance method Private Method get list of partitions (NR Partitioning) 20090317
15 GET_ROWS_IN_PARTITION Instance method Private Method get number of rows in partition 20090317
16 PART_ADD_NR Instance method Private Method add spare partitions (NR partitioning) 20090317
17 PART_ADD_NR_NEXTYEAR Instance method Private Method add next year entries 20090630
18 PART_ADD_NR_SUBNYONLY Instance method Private Method add next year entries for subobjects with no NR partitions 20090630
19 PART_MERGE_NR Instance method Private Method merge partitions (NR partitioning) 20090317
20 READ_PARTITIONS Static method Public Method select partitions 20090317
21 READ_PARTITION_FIELDS Static method Public Method select partition key fields 20090317
22 RUNCOMMANDS Instance method Private Method execute sql and update admin data 20090317
23 SAVE_NRDATA Static method Public Method Save changed nr data 20090317
24 SAVE_PARTADM Static method Public Method save partadm 20090317
25 SCHEDULE_JOB Static method Public Method schedule RSORAPARTADM in batch 20090317
26 START_ADMIN_TASK Instance method Public Method start admin task 20090317
27 TOASCII Static method Private Method char to ascii 20090317
28 WRITE_STRING_FORMATED Instance method Private Method write string formated 20090317
Events
Class CL_ORA_PARTENGINE_ADMIN has no event.
Types
Class CL_ORA_PARTENGINE_ADMIN has no local type.
Method Signatures

Method ADD_BASE_DATA 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 STATUS Call by reference Type reference (TYPE) I 20090317
3 Importing TESTMODEFORCE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20090317
4 Changing WA_ADM_BASE Call by reference Type reference (TYPE) ORAPR_S_ADM_BASE 20090317

Method ADD_BASE_DATA on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method ASCIITOCHAR Signature

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

Method ASCIITOCHAR on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method CONSTRUCTOR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing LOGLEVEL Call by reference Type reference (TYPE) I 0 20100419
2 Importing MAXROWS_EXCLUDE_PAR Call by reference Type reference (TYPE) I 1000000 20090317
3 Importing MAXROWS_MERGE_PAR Call by reference Type reference (TYPE) I 5000 20090317
4 Importing PARALLEL_DEGREE Call by reference Type reference (TYPE) I 4 20090317
5 Importing TABNAME Call by reference Type reference (TYPE) TABNAME 20090317
6 Importing TESTMODEFORCE Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20090317

Method CONSTRUCTOR on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method CREATE_MERGE_ENTRY Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing IT_OUTPUT Call by reference Type reference (TYPE) ORAPR_T_WRITE 20090317
2 Importing PART_MERGETARGET Call by reference Type reference (TYPE) FIELDNAME 20090317
3 Importing PART_TOMERGE Call by reference Type reference (TYPE) FIELDNAME 20090317
4 Importing ROWS_MERGETARGET Call by reference Type reference (TYPE) I 20090317
5 Importing ROWS_TOMERGE Call by reference Type reference (TYPE) I 20090317
6 Importing TABNAME Call by reference Type reference (TYPE) TABNAME 20090317
7 Importing TESTMODE Call by reference Type reference (TYPE) ORAPR_S_ADMIN-ADDPART 20090317
8 Exporting WA_DDL Value transfer Type reference (TYPE) ORAPR_S_DDL 20090317

Method CREATE_MERGE_ENTRY on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method CREATE_NEWPART_ENTRY Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IS_MAXPART Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20090317
2 Changing IT_OUTPUT Call by reference Type reference (TYPE) ORAPR_T_WRITE 20090317
3 Exporting NEW_PARTITION Call by reference Type reference (TYPE) FIELDNAME 20090317
4 Importing NRL_NEWPART Call by reference Type reference (TYPE) STRING 20090317
5 Importing PARTNUMBER Call by reference Type reference (TYPE) ORAPR_S_NR_SP_CL-SP_HIGHNUM '00000' 20090317
6 Importing PART_TO_SPLIT Call by reference Type reference (TYPE) FIELDNAME 20090317
7 Importing PTYPE Call by reference Type reference (TYPE) ORAPR_S_ADMIN-PTYPE 20090317
8 Importing ROWS_PART_TO_SPLIT Call by reference Type reference (TYPE) I 20090630
9 Importing TABALIAS Call by reference Type reference (TYPE) TABNAME 20090317
10 Importing TABNAME Call by reference Type reference (TYPE) TABNAME 20090317
11 Importing TESTMODE Call by reference Type reference (TYPE) ORAPR_S_ADMIN-ADDPART 20090317
12 Exporting WA_DDL Value transfer Type reference (TYPE) ORAPR_S_DDL 20090317
13 Importing WA_NRIV_ADM Call by reference Type reference (TYPE) ORAPR_S_NR_SP_CL 20090317

Method CREATE_NEWPART_ENTRY on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method CREA_PART_STATISTICS Signature

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

Method CREA_PART_STATISTICS on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method DISPLAY_JOBS Signature

Method DISPLAY_JOBS on class CL_ORA_PARTENGINE_ADMIN has no parameter.
Method DISPLAY_JOBS on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method GET_ADM_DATA 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 TABNAME Call by reference Type reference (TYPE) TABNAME 20090317
3 Importing TESTMODEFORCE Call by reference Type reference (TYPE) ABAP_BOOL 20090317

Method GET_ADM_DATA on class CL_ORA_PARTENGINE_ADMIN 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_ADMIN 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 Single-Character Flag 20090630
2 Importing CHAR_TO_CHANGE Call by reference Type reference (TYPE) CHAR1 Single-Character Flag 20090630

Method GET_LOWERCHAR on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method GET_MAXNRVALUE_IN_PART Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing FIELDNAME Call by reference Type reference (TYPE) FIELDNAME 20090317
2 Changing IT_OUTPUT Call by reference Type reference (TYPE) ORAPR_T_WRITE 20090317
3 Importing NRINFO Call by reference Type reference (TYPE) INROI 20090317
4 Exporting NRL_IN_PART Call by reference Type reference (TYPE) ORADEC20 20090317
5 Importing PARTITION_NAME Call by reference Type reference (TYPE) FIELDNAME 20090317
6 Exporting RC Call by reference Type reference (TYPE) I 20090317
7 Importing TABNAME Call by reference Type reference (TYPE) TABNAME 20090317

Method GET_MAXNRVALUE_IN_PART on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method GET_NR_FROM_TONUMBER Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing NROBJECT Call by reference Type reference (TYPE) NROBJ 20090317
2 Changing WA_NRIV_ADM Call by reference Type reference (TYPE) ORAPR_S_NR_SP_CL 20090317

Method GET_NR_FROM_TONUMBER on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method GET_PARTADM_LIST Signature

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

Method GET_PARTADM_LIST on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method GET_PARTITIONS_NR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting IT_ADM_PART_NR Call by reference Type reference (TYPE) ORAPR_T_ADMNR_PART 20090317
2 Exporting IT_OUTPUT Call by reference Type reference (TYPE) ORAPR_T_WRITE 20090317
3 Importing PTYPE Call by reference Type reference (TYPE) ORAPR_S_ADMIN-PTYPE 20090317
4 Exporting RC Call by reference Type reference (TYPE) I 20090317
5 Importing TABNAME Call by reference Type reference (TYPE) TABNAME 20090317

Method GET_PARTITIONS_NR on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method GET_ROWS_IN_PARTITION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing IT_OUTPUT Call by reference Type reference (TYPE) ORAPR_T_WRITE 20090317
2 Exporting NUM_ROWS Value transfer Type reference (TYPE) I 20090317
3 Importing PARTITION_NAME Call by reference Type reference (TYPE) FIELDNAME 20090317
4 Exporting RC Call by reference Type reference (TYPE) I 20090317
5 Importing TABNAME Call by reference Type reference (TYPE) TABNAME 20090317
6 Importing UPTOMAX Call by reference Type reference (TYPE) I 20090317

Method GET_ROWS_IN_PARTITION on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method PART_ADD_NR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_ADM_PART_NR Call by reference Type reference (TYPE) ORAPR_T_ADMNR_PART 20090317
2 Exporting IT_OUTPUT Call by reference Type reference (TYPE) ORAPR_T_WRITE 20090317
3 Importing NRINFO Call by reference Type reference (TYPE) INROI 20090317
4 Changing WA_ADMIN_DATA Call by reference Type reference (TYPE) ORAPR_S_ADMIN 20090317

Method PART_ADD_NR on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method PART_ADD_NR_NEXTYEAR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_ADM_PART_NR Call by reference Type reference (TYPE) ORAPR_T_ADMNR_PART 20090630
2 Changing IT_DDL Call by reference Type reference (TYPE) ORAPR_T_DDL 20090630
3 Changing IT_OUTPUT Call by reference Type reference (TYPE) ORAPR_T_WRITE 20090630
4 Importing NRINFO Call by reference Type reference (TYPE) INROI Number range object information structure 20090630
5 Importing WA_ADMIN_DATA Call by reference Type reference (TYPE) ORAPR_S_ADMIN 20090630

Method PART_ADD_NR_NEXTYEAR on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method PART_ADD_NR_SUBNYONLY Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_ADM_PART_NR Call by reference Type reference (TYPE) ORAPR_T_ADMNR_PART 20090630
2 Changing IT_DDL Call by reference Type reference (TYPE) ORAPR_T_DDL 20090630
3 Changing IT_OUTPUT Call by reference Type reference (TYPE) ORAPR_T_WRITE 20090630
4 Importing WA_ADMIN_DATA Call by reference Type reference (TYPE) ORAPR_S_ADMIN 20090630

Method PART_ADD_NR_SUBNYONLY on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method PART_MERGE_NR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_ADM_PART_NR Call by reference Type reference (TYPE) ORAPR_T_ADMNR_PART 20090317
2 Exporting IT_OUTPUT Call by reference Type reference (TYPE) ORAPR_T_WRITE 20090317
3 Importing NRINFO Call by reference Type reference (TYPE) INROI 20090317
4 Changing WA_ADMIN_DATA Call by reference Type reference (TYPE) ORAPR_S_ADMIN 20090317

Method PART_MERGE_NR on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method READ_PARTITIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting IT_PARTITIONS Call by reference Type reference (TYPE) ORAPR_T_PART 20090317
2 Importing PARTLISTINFO Call by reference Type reference (TYPE) ABAP_BOOL ABAP_FALSE 20090317
3 Exporting RC Call by reference Type reference (TYPE) I 20090317
4 Exporting SQLERR_REF Call by reference Object reference (TYPE REF TO) CX_SQL_EXCEPTION 20090317
5 Exporting SQL_STMT Call by reference Type reference (TYPE) STRING 20090317
6 Importing TABNAME Call by reference Type reference (TYPE) TABNAME 20090317

Method READ_PARTITIONS on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method READ_PARTITION_FIELDS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting IT_PARTFIELDS Call by reference Type reference (TYPE) ORAPR_T_PARTFIELDS 20090317
2 Exporting RC Call by reference Type reference (TYPE) I 20090317
3 Exporting SQLERR_REF Call by reference Object reference (TYPE REF TO) CX_SQL_EXCEPTION 20090317
4 Exporting SQL_STMT Call by reference Type reference (TYPE) STRING 20090317
5 Importing TABNAME Call by reference Type reference (TYPE) TABNAME 20090317

Method READ_PARTITION_FIELDS on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method RUNCOMMANDS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_DDL Call by reference Type reference (TYPE) ORAPR_T_DDL 20090317
2 Changing IT_OUTPUT Call by reference Type reference (TYPE) ORAPR_T_WRITE 20090317
3 Exporting RC Value transfer Type reference (TYPE) SY-SUBRC 20090317
4 Changing WA_ADMIN_DATA Call by reference Type reference (TYPE) ORAPR_S_ADMIN 20090317

Method RUNCOMMANDS on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method SAVE_NRDATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing ACTION Call by reference Type reference (TYPE) ORAPR_S_NR_SP_CL-ACTION 20090720
2 Importing DELTA Call by reference Type reference (TYPE) I 20090317
3 Changing IT_PARTLIST Call by reference Type reference (TYPE) ORAPR_T_PART 20090317
4 Importing SPARE Call by reference Type reference (TYPE) NUMC2 20090317
5 Importing TABNAME Call by reference Type reference (TYPE) TABNAME 20090317
6 Changing WA_PARTLIST Call by reference Type reference (TYPE) ORAPR_S_PART 20090317

Method SAVE_NRDATA on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method SAVE_PARTADM Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing IT_PARTADM Call by reference Type reference (TYPE) ORAPR_T_PARTADM_ALV 20090317

Method SAVE_PARTADM on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method SCHEDULE_JOB Signature

Method SCHEDULE_JOB on class CL_ORA_PARTENGINE_ADMIN has no parameter.
Method SCHEDULE_JOB on class CL_ORA_PARTENGINE_ADMIN has no exception.

Method START_ADMIN_TASK Signature

Method START_ADMIN_TASK on class CL_ORA_PARTENGINE_ADMIN has no parameter.
Method START_ADMIN_TASK on class CL_ORA_PARTENGINE_ADMIN 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_ADMIN has no exception.

Method WRITE_STRING_FORMATED Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing IT_OUTPUT Call by reference Type reference (TYPE) ORAPR_T_WRITE 20090317
2 Importing STRTEXT Call by reference Type reference (TYPE) STRING 20090317

Method WRITE_STRING_FORMATED on class CL_ORA_PARTENGINE_ADMIN has no exception.
History
Last changed by/on SAP  20110908 
SAP Release Created in