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
)