How to Migrate IP Data Without Deleting The Old Records? (Doc ID 1559503.1)

Last updated on MAY 21, 2015

Applies to:

Oracle Adaptive Access Manager - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Goal

We have OAAM 11.1.1.5.0 installed. We have experienced same issue of Bug 11836166 : OAAM NOT DISPLAYING IP LOCATION CORRECTLY FOR SPLIT ADDRESS RANGES
Part of solution that provided by SR 3-6945667621 is to run the following SQL statements after applied to BP02.

However, according to our DBA recommended, those SQL statements SHOULD NOT be run in our production environment. Due to the reason that those SQL statement will going to delete 2+ million records in our prod database, and we have to turn off logging in order to have this run. However, due to this database also share with another live applications, turn off logging is NOT possible.

ALTER TABLE "VCRYPT_CITY" DISABLE CONSTRAINT "V_CITY_FK0";
ALTER TABLE "VCRYPT_IP_LOCATION_MAP" DISABLE CONSTRAINT
"V_IP_LOCATION_MAP_FK0";
ALTER TABLE "VCRYPT_IP_LOCATION_MAP" DISABLE CONSTRAINT
"V_IP_LOCATION_MAP_FK1";
ALTER TABLE "VCRYPT_IP_LOCATION_MAP" DISABLE CONSTRAINT
"V_IP_LOCATION_MAP_FK2";
ALTER TABLE "VCRYPT_IP_LOCATION_MAP" DISABLE CONSTRAINT
"V_IP_LOCATION_MAP_FK3";
ALTER TABLE "VCRYPT_IP_LOCATION_MAP" DISABLE CONSTRAINT
"V_IP_LOCATION_MAP_FK4";
ALTER TABLE "VCRYPT_STATE" DISABLE CONSTRAINT "V_STATE_FK0";

delete vcrypt_ip_location_map;
delete vcrypt_isp;
delete vcrypt_city;
delete vcrypt_state;
delete vcrypt_country;
delete v_ip_loc_map_split;
delete v_loc_lookup;

ALTER TABLE "VCRYPT_CITY" ENABLE CONSTRAINT "V_CITY_FK0";
ALTER TABLE "VCRYPT_IP_LOCATION_MAP" ENABLE CONSTRAINT
"V_IP_LOCATION_MAP_FK0";
ALTER TABLE "VCRYPT_IP_LOCATION_MAP" ENABLE CONSTRAINT
"V_IP_LOCATION_MAP_FK1";
ALTER TABLE "VCRYPT_IP_LOCATION_MAP" ENABLE CONSTRAINT
"V_IP_LOCATION_MAP_FK2";
ALTER TABLE "VCRYPT_IP_LOCATION_MAP" ENABLE CONSTRAINT
"V_IP_LOCATION_MAP_FK3";
ALTER TABLE "VCRYPT_IP_

Is there an alternate way, that's faster to run to work around this?
 

Solution

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