An India-based global leader in Energy and Process Automation Solutions has been a customer of Doyensys for several years. Along the way, Doyensys has established itself as a trusted partner through our commitment and Oracle expertise.
What was the problem statement?
While working on a project to migrate their EBS and databases from on-premise to OCI IAAS servers, the client encountered a unique problem. It was a situation where they needed the intervention of Oracle experts.
During the initial iterations of the EBS/Database migration, the client detected corruption in the FND_LOBS table. It was a bottleneck that needed instant resolution for the success of the migration.
The OCI team, which was working on the migration, rightly advised the client to not proceed with the migration unless the corruption was fixed. Due to this issue, they had to put the OCI migration project on hold for a short time.
How did the Doyensys team resolve the problem?
Although it required a lot of effort, the team at Doyensys was successful in identifying the corrupted records in the FND_LOBS table. They removed each of these records and also came up with a permanent solution. They suggested exporting/truncating/importing the FND_LOBS table to avoid similar problems in the future.
What were the challenges that came along the way?
The FND_LOBS table was huge (1.5 TB), and the estimated time to perform the expdp/impdp operation was around 72 hours. Such a huge business downtime was impossible, and it wasn’t something that the customer could afford.
What did the Doyensys team do?
The Doyensys team was sensitive to the demands of the customer. They understood that 72 hours for performing authentic expdp/impdp of the table was not feasible. The team rightly proposed splitting the expdp/impdp operation into ten small tasks. It allowed them to divide the records of the FND_LOBS table into ten smaller chunks using the parameter QUERY.
Although it seemed good on paper, it was an atypical method. Since it hadn’t been used widely, the team could not find any supporting documents. However, the team at Doyensys could pull it off for a major seeded table like FND_LOBS.
What was the business impact of this project?
Apart from executing a project that was touted as impossible, Doyensys was also able to finish the project in 40 hours against the given timeline of 72 hours.
In Conclusion
It was a project that further proved the capability of Doyensys when it comes to executing challenging Oracle projects. We are proud of our team that could propose and implement an atypical method such as this one.
