My Oracle Support Banner

OAAM 11g : How to Migrate IP Data Without Deleting The Old Records (Doc ID 1559503.1)

Last updated on OCTOBER 14, 2019

Applies to:

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

Goal

Customer have experienced same issue of <Bug:11836166> : OAAM NOT DISPLAYING IP LOCATION CORRECTLY FOR SPLIT ADDRESS RANGES.

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 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";

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

Solution

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
Goal
Solution
References


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