问题描述
我想将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错误.在创建存储库之前尝试删除存储库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！