Issue with APT_ORACLE_LOAD_OPTIONS
Posted: Tue Mar 29, 2005 12:57 pm
Hi,
I was running dataset to Oracle load jobs...I encountered the following errors:
Stg_AdcCustomerNodeHistory_Load: query 'select count(*) from
ALL_PART_INDEXES where TABLE_NAME = upper('STG_ADC_CUSTOMER_NODE_HISTORY')
and OWNER = upper('HUBPRODSTG')
' returned 0
Stg_AdcCustomerNodeHistory_Load: Index option rebuild has been included. In order for this option to be applicable and to work properly, environment variable APT_ORACLE_LOAD_OPTIONS should contain the options DIRECT and PARALLEL set to TRUE, and the option SKIP_INDEX_MAINTENANCE set to YES.This variable has been set by the user to 'OPTIONS(DIRECT=TRUE,PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE=YES)'.
Initially, the values for the environment variable "APT_ORACLE_LOAD_OPTIONS " is not set. The error hinted to add the variable and set the options. Even after including the variable and the options, we still were unable to run the jobs successfully.
Please let me know what more needs to be done?
Cheers,
Mohan
I was running dataset to Oracle load jobs...I encountered the following errors:
Stg_AdcCustomerNodeHistory_Load: query 'select count(*) from
ALL_PART_INDEXES where TABLE_NAME = upper('STG_ADC_CUSTOMER_NODE_HISTORY')
and OWNER = upper('HUBPRODSTG')
' returned 0
Stg_AdcCustomerNodeHistory_Load: Index option rebuild has been included. In order for this option to be applicable and to work properly, environment variable APT_ORACLE_LOAD_OPTIONS should contain the options DIRECT and PARALLEL set to TRUE, and the option SKIP_INDEX_MAINTENANCE set to YES.This variable has been set by the user to 'OPTIONS(DIRECT=TRUE,PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE=YES)'.
Initially, the values for the environment variable "APT_ORACLE_LOAD_OPTIONS " is not set. The error hinted to add the variable and set the options. Even after including the variable and the options, we still were unable to run the jobs successfully.
Please let me know what more needs to be done?
Cheers,
Mohan