My Oracle Support Banner

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 DECEMBER 03, 2019

Applies to:

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


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




To view full details, sign in with your My Oracle Support account.

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

In this Document

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