Search code examples
oracleoracle-sqldeveloper

Migrate SQL Server Database to Oracle using SQL Developer on same system not work

I have a SQL Server database with name test3 that have 1 table with name A that have 1 column with 5 rows, I want migrate to Oracle but it gives an error before I enter Oracle password as shown as.

enter image description here

Error message: enter image description here

Note: I grant all privileges to migration-name (MyCon) but not work.

GRANT ALL PRIVILEGES to {migration-name} identified by {migration-name};

My Oracle version: 19C and Oracle SQL Developr version=19.2.206 .

Solution

  • Most common reason I've seen the Migration Repository from being created correctly no newer instances of Oracle is that the user associated with the schema lacks QUOTA on the user's default tablespace.

    Try something like this :

    ALTER USER X QUOTA UNLIMITED ON Y

    Where X is the USER and Y is the TABLESPACE