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

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.

Error message:

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 .

CodePudding user response：

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