Running, locupd Using staxzip4.vdf, and the Q Series GeoCoder Monthly Update Program Completes in Error - ORA-01632: Max # Extents (505) Reached In Index VERTEX.LOCZIP9GEO

(Doc ID 1953901.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle E-Business Tax - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

You have left ZIP+4 update, while upgrading, since it is optional and you want to implement it now.

You are attempting to run locupd, using staxzip4.vdf, and the Q Series GeoCoder Monthly Update Program receives the following error:

Main Menu
---------
1. - Update GeoCoder Database.
2. - Update ZIP+4 Data in GeoCoder Database.

9. - Exit.

Enter Selection: 2

Beginning ZIP+4 Update Process

Enter GeoCoder Data Source:
Enter GeoCoder Server Name: NAME OF SERVER
Enter GeoCoder User ID: userid
Enter GeoCoder User Password: password
GeoCoder Update Setup:
(1=Do Not include township records, 2=Include township records): 2
Enter the path of the update files: /d21/oraaltd/NAME OF SERVER/apps/apps_st/appl/vertex/update4.1_387
Updating ZIP+4 database. Please Wait...

GeoCoder Database Error:
ORA-01632: max # extents (505) reached in index VERTEX.LOCZIP9GEO

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms