Share via

SSMA for Oracle error ROW-00001 Unable to Allocate Memory

Vincent Molloy 0 Reputation points
Sep 26, 2024, 5:38 PM

Hi,

I am migrating from Oracle to Azure SQL Server Managed Instance. Some of my tables have 100+ million rows so I have partitioned those tables in the source Oracle database so I am only migrating smaller tables to Managed Instance (typically between 3M and 10M rows).

I am using the 32 Bit SSMA for Oracle application (could never get the 64 bit version to work reliably).

The source database is Oracle 12c Enterprise 12.1.0.2.0

Target is Azure SQL Managed Instance (General Purpose Premium-series (1024 GB storage, 4 vCores)

I am using Oracle 32 bit client

I am using the OLEDB Provider (Oracle ODP Provider for .NET does not work because it always reports an error about invalid login despite entering the correct username and password).

The issue I am having is that I get lots of "ROW-00001 Unable to allocate memory" errors. Eventually, SSMA crashes with no error. I have to trawl through the logs to figure out which tables migrated successfully. Then I strip these out of my project and go again.

I repeat this process until all tables successfully migrate. Needless to say this is very frustrating!

I have repeated this process many times and there does not appear to be any pattern to which tables are involved.

I'd be grateful for a solution to this issue that allows me to run my migration end-to-end without issues.

Thanks in advance,

Vincent

Azure SQL Database
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
540 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.