REFRESH_LOADERΒΆ

Change the TSA table structure if the structure of the corresponding source table was changed.

Parameter Name

Required

DefaultValue

Parameter-Description

p_ldr_name

no

Name of the loader process for a specific data table as defined in DBI_LOADER.LDR_NAME (null used to execute script for all loaders)

p_bdomain

no

Name of the business domain as defined in DBI_BDOMAIN_SETTINGS.BDOMAIN (null used to execute script for all loaders)

p_force

yes

false

force execution of DDL result statements, false just generates an output

Example

execute script api_dbiadm.refresh_loader
                  ( 'XXXXXXXXXXXX'  -- p_ldr_name
                  , 'XXXXXXXXXX'    -- p_bdomain
                  , false           -- p_force
                  )