4254: l_industry,
4255: l_ams_schema
4256: );
4257:
4258: DBMS_STATS.gather_table_stats (
4259: ownname => l_ams_schema,
4260: tabname => 'AMS_DM_PARTY_DETAILS',
4261: estimate_percent => 99,
4262: cascade => TRUE
4261: estimate_percent => 99,
4262: cascade => TRUE
4263: );
4264:
4265: DBMS_STATS.gather_table_stats (
4266: ownname => l_ams_schema,
4267: tabname => 'AMS_DM_PARTY_DETAILS_TIME',
4268: estimate_percent => 99,
4269: cascade => TRUE
4268: estimate_percent => 99,
4269: cascade => TRUE
4270: );
4271:
4272: DBMS_STATS.gather_table_stats (
4273: ownname => l_ams_schema,
4274: tabname => 'AMS_DM_SOURCE',
4275: estimate_percent => 99,
4276: cascade => TRUE