Release 12 - Field Service Spatial Upgrading Document (Doc ID 416736.1)

Last updated on SEPTEMBER 14, 2023

Applies to:

Goal

Beginning release R12, Customers using prior versions of the North American (or United Kingdom) Dataset will need to upgrade to the Q1 2005 North American (or United Kingdom) Dataset. 

Though originally created for the 2005 dataset, the steps in this note apply to 2008 datasets too. The only thing different would be the number of records inserted in the tables by the navteq data. The script in step 1c of section 2 will work for all versions. Just the tablecounts mentioned after that are specific to 2005.

The benefits derived from upgrading to this new dataset include improved performance for Advanced Scheduler and the Map viewer and more comprehensive coverage.

This document is split up
Section 1: Navteq Spatial Data - Pre Installation Steps
Section 2: Navteq Spatial Data Installation
Section 3: Navteq Spatial Data - Post Installation Steps
Section 4: Mapviewer Implementation

This document outlines the procedures, steps and the relevant sections that need to be followed in order to:

• Migrate from Oracle Corp. apps release 11i using Navteq Datasets prior to the Q1 2005 NA (or UK) Dataset
    a. In release 11i, the indexes are created as CSF user.
          i. To upgrade to release R12, these indexes created as CSF user have to be explicitly dropped. 
          ii. To drop indexes from CSF schema, use the drop script csfgeoidxdo.sql which is located at $CSF_TOP/patch/115/sql.
          iii. Then, follow the steps laid out in this guide.
  
  
• Migrate from Oracle Corp. apps release 11i using Navteq Q1 2005 North American (or United Kingdom) Dataset 
  a. There is no need to upload the Navteq Dataset
  b. Drop and re-create the indexes
         i. To drop indexes from CSF schema, use the drop script csfgeoidxdo.sql which is located at $CSF_TOP/patch/115/sql 
         ii. Please execute the Steps 2 & 3 in Section 3 and all the steps in Section 4. 
  
  
•  Complete new installation of release R12.
  a. The entire guide needs to be followed.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.