O2SS0050 Conversion of Identifier not supported (CHAR, BINARY_INTEGER, BOOLEAN) is not supported

65877627 0 Reputation points
2023-11-27T10:24:40.6033333+00:00

Hi,

I've checked common conversion errors for Oracle Database to SQL Server 2016 migration with SSMA (https://learn.microsoft.com/en-us/sql/ssma/oracle/messages/o2ss0007?view=sql-server-ver16) however this error is missing 02SS0050, Conversion of Identifier not supported (CHAR, BINARY_INTEGER, BOOLEAN) is not supported. Below you find the details of the error. Can someone help me convert this and show how to convert it so that the procedure ANALYSE_SCHEMA can work and be migrated to the SQL Server 2016 and Data can be migrated?

The Procedure in Oracle DB on Windows 2003 server is doing this:

ORACLE PROCEDURE:

CREATE OR REPLACE
PROCEDURE ANALYSE_SCHEMA
AS
BEGIN
DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME => 'XYZ', estimate_PERCENT => 10, cascade => TRUE);
END;

The error with SSMA is:

CREATE PROCEDURE ANALYSE_SCHEMA
AS
BEGIN

/*

  •   SSMA error messages:
  •   O2SS0050: Conversion of identifier 'DBMS_STATS.GATHER_SCHEMA_STATS(CHAR, BINARY_INTEGER, BOOLEAN)' is not supported.

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME = 'XYZ', ESTIMATE_PERCENT = 10, [CASCADE] = 1)
*/

DECLARE
@db_null_statement int

END
GO

Thanks.

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.
509 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Greg Low 1,680 Reputation points Microsoft Regional Director
    2024-02-27T23:49:30.48+00:00
    0 comments No comments