执行脚本时出现sql错误.在创建存储库之前尝试删除存储库 [英] sql error on script execution. try deleting repository before creating repository

问题描述

我想将mysql数据库迁移到oracle. 我已经从此URL http://进行了迁移演示www.oracle.com/technetwork/database/migration/connect-step-mysql-1946352.html

I want to migrate my mysql databse to oracle. I have followed the migration demo from this url http://www.oracle.com/technetwork/database/migration/connect-step-mysql-1946352.html

但是在尝试关联迁移存储库

but I got this message when try to associate migration repository

sql error on script execution. try deleting repository before creating repository

我正在使用
Oracle Sql Developer v 4.1.1.19
Oracle Express Edition 11g发行版2

I am using
Oracle Sql Developer v 4.1.1.19
Oracle express edition 11g releas 2

看下面的图片，我已逐步尝试过

see the picture bellow what I have tried step by step

第一步:创建一个名为 migration_repo

step1: Creating a user named migration_repo

第2步:使用 migration_repo 用户创建名为 migration_repo 的连接

step 2: Creating connection named migration_repo using migration_repo user

第3步:尝试关联迁移存储库

step3: try to associate migration repository

第4步:执行命令

，但是几秒钟后，我收到了此错误消息.

but after few seconds I got this error message.

现在.我该如何解决?我做错了什么?

Now. how can I solve this? what I have done wrong?

推荐答案

我遇到了同样的问题，此问题通过使用...更改GRANT语句来解决.

I had the same problem, this was solved changing the GRANT statement with...

将所有特权授予由{migration-name}标识的{migration-name}；

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

请注意在执行迁移任务后删除特权.

just be aware to remove privileges after migration tasks.

这篇关于执行脚本时出现sql错误.在创建存储库之前尝试删除存储库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！