Azure SQL Database
An Azure relational database service.
5,787 questions
SSMA for Oracle error ROW-00001 Unable to Allocate Memory
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 50%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vincent Molloy
0
Reputation points
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
{count} votes
-
Erland Sommarskog 112.8K Reputation points2024-09-26T21:15:58.4+00:00 Some googling tells me that the error comes from the OLE DB Provider. But that could be due to bad habits from SSMA. Or that your database is simply too big for SSMA.
I should clarify that I have never worked with Oracle or SSMA. But my experience is that such assistants only work to a certain level, and when your source database is too complex or too big, you have to tweak it or roll your own.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA 3,425 Reputation points Microsoft Vendor2024-09-30T17:04:12.9133333+00:00 @Vincent Molloy
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help. -
NIKHILA NETHIKUNTA 3,425 Reputation points Microsoft Vendor
2024-10-01T18:07:53.1633333+00:00 @Vincent Molloy
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer