使用sqldeveloper19将sqlsever数据库迁移到Oracle

最新推荐文章于 2024-10-31 10:35:06 发布

猩猩的天空

最新推荐文章于 2024-10-31 10:35:06 发布

阅读量783

点赞数 1

分类专栏： oracle学习 sqlserver 软件操作技巧

本文链接：https://blog.youkuaiyun.com/yuanlin1318/article/details/103582297

版权

软件操作技巧同时被 3 个专栏收录

33 篇文章

订阅专栏

oracle学习

6 篇文章

订阅专栏

sqlserver

4 篇文章

订阅专栏

1.建立资料档案库（Migration Repository）

1.1 资料档案库用户(migrations)

-- Create the user 
create user MIGRATIONS

identified by MIGRATIONS 
  default tablespace USERS 
  temporary tablespace TEMP 
  profile DEFAULT; 
-- Grant/Revoke role privileges 
grant connect to MIGRATIONS with admin option; 
grant resource to MIGRATIONS with admin option; 
-- Grant/Revoke system privileges 
grant alter any role to MIGRATIONS; 
grant alter any sequence to MIGRATIONS; 
grant alter any table to MIGRATIONS; 
grant alter any trigger to MIGRATIONS; 
grant alter tablespace to MIGRATIONS; 
grant comment any table to MIGRATIONS; 
grant create any sequence to MIGRATIONS; 
grant create any table to MIGRATIONS; 
grant create any trigger to MIGRATIONS; 
grant create any view to MIGRATIONS; 
grant create materialized view to MIGRATIONS with admin option; 
grant create public synonym to MIGRATIONS with admin option; 
grant create role to MIGRATIONS; 
grant create session to MIGRATIONS with admin option; 
grant create synonym to MIGRATIONS with admin option; 
grant create tablespace to MIGRATIONS; 
grant create user to MIGRATIONS; 
grant create view to MIGRATIONS with admin option; 
grant drop any role to MIGRATIONS; 
grant drop any sequence to MIGRATIONS; 
grant drop any table to MIGRATIONS; 
grant drop any trigger to MIGRATIONS; 
grant drop tablespace to MIGRATIONS; 
grant drop user to MIGRATIONS; 
grant grant any role to MIGRATIONS; 
grant insert any table to MIGRATIONS; 
grant select any table to MIGRATIONS; 
grant unlimited tablespace to MIGRATIONS with admin option; 
grant update any table to MIGRATIONS;