Migration

Migration Error “sql error on script execution. try deleting repository before creating repository”

I got this message when try to associate migration repository.

I created a user for the migration repository

  • CREATE USER yatt IDENTIFIED BY yatt;
    user created.
  • DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
    Grant succeeded.

Installing Repository:

Ekran Resmi 2017-10-14 23.28.44

Error Messages:

Ekran Resmi 2017-10-14 23.31.31

Ekran Resmi 2017-10-14 23.38.35

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.

  • GRANT CONNECT, RESOURCE, CREATE SESSION, CREATE VIEW TO yatt;
    Grant succeeded.

Ekran Resmi 2017-10-14 23.39.35

Ekran Resmi 2017-10-14 23.28.33

Migration repository associated.

Advertisements
Standard