Problem

As soon as a user launches locator, the initial extent of the map appears.  However, the image is very small due to the size of the initial extent that has been set.

Solution

In order to reset the size of the initial extent and match that which displays the local county, please run the following SQL statements:

1.

update mdsys.sdo_geom_metadata_table

set sdo_diminfo = ( select diminfo from user_sdo_geom_metadata where table_name = 'NETWORK_SDO_TABLE' )

where sdo_table_name = 'NM_NSG_ESU_SHAPES_TABLE'

and sdo_column_name = 'SHAPE'

and sdo_owner = sys_context('NM3CORE', 'APPLICATION_OWNER');

2. 

delete from centsize;

3.

begin

mapviewer.set_cent_size_theme;

end;

/

Once run, please restart the mapserver and launch Locator.