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
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.
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:
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
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