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

问题描述

我想将我的 mysql 数据库迁移到 oracle.我已经从这个 url

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

step3:尝试关联迁移仓库

step4:执行命令

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

现在.我该如何解决这个问题?我做错了什么?

解决方案

我遇到了同样的问题，这解决了更改 GRANT 语句...

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

请注意在迁移任务后删除权限.

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

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

step1: Creating a user named migration_repo

step 2: Creating connection named migration_repo using migration_repo user

step3: try to associate migration repository

step4: executing the command

but after few seconds I got this error message.

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

解决方案

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

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

just be aware to remove privileges after migration tasks.

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