数据库版本oracle 11g R2;
需将数据库整库从AIX 搬迁到windows 2008上,用expdp/imdp很多的依赖关系不好解决,导致太多对象无法编译。
现想系统表空间和用户表空间整体迁移,但两种操作系统endian_format不一样,不知表空间传输能否对系统表空间进行迁移?
同时表空间传输还有其他限制(如表空间需自包含)? 有没有什么较好的方案实现我的要求?
select * from v$transportable_platform;
1 Solaris[tm] OE (32-bit) Big
2 Solaris[tm] OE (64-bit) Big
7 Microsoft Windows IA (32-bit) Little
10 Linux IA (32-bit) Little
6 AIX-Based Systems (64-bit) Big
3 HP-UX (64-bit) Big
5 HP Tru64 UNIX Little
4 HP-UX IA (64-bit) Big
11 Linux IA (64-bit) Little
15 HP Open VMS Little
8 Microsoft Windows IA (64-bit) Little
9 IBM zSeries Based Linux Big
13 Linux x86 64-bit Little
16 Apple Mac OS Big
12 Microsoft Windows x86 64-bit Little
17 Solaris Operating System (x86) Little
18 IBM Power Based Linux Big
19 HP IA Open VMS Little
20 Solaris Operating System (x86-64) Little
21 Apple Mac OS (x86-64) Little