Since Oracle Version 10G ist is possible to transfer tablespaces no longer only between platforms of the same architecture. Now in 10G it also possible to transport from any platform to any platform, provided the platforms belong to the list below:<\/p>\n
SQL> select * from v$transportable_platform;<\/font><\/em><\/p>\n PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT But be aware that depending on which plattforms we deal with there might be some converting necessary or not!<\/font><\/span><\/strong><\/p>\n To help you with that, I have carried together the little cook book about “How to do” below:<\/p>\n 1. Set the tablespace to READ ONLY<\/u><\/p>\n SQL> alter tablespace USERS read only; 2. Export metadata<\/p>\n exp userid=\\’\/ as sysdba\\’ transport_tablespace=y 3. Converting tablespace if necessary<\/u><\/p>\n Depending on we have to convert the file between endianness Little<\/strong> and endianness Big<\/strong> (forward or backward) we can do that with RMAN:<\/p>\n rman target=\/<\/em><\/p>\n Recovery Manager: Release 10.2.0.3.0 – Production on Wed Dec 10 13:10:57 2008 RMAN> convert tablespace ‘USERS’ 4. Move datafiles and export dump file<\/u><\/p>\n $ftp users_tts.dmp<\/em><\/p>\n and \/database\/orav10\/datafiles\/users.dbf<\/em> (no conversion) 5. Import metadata<\/u><\/p>\n imp userid=\\’\/ as sysdba\\’ TRANSPORT_TABLESPACE=Y 6. Set the tablespace to READ WRITE<\/u><\/p>\n SQL> alter tablespace USERS read write; Since Oracle Version 10G ist is possible to transfer tablespaces no longer only between platforms of the same architecture. Now in 10G it also possible to transport from any platform to any platform, provided the platforms belong to the list below: SQL> select * from v$transportable_platform; PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT 1 Solaris[tm] OE […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,5,166,31,15,16],"tags":[196,195,194,197,198,257,199,43,193],"class_list":["post-210","post","type-post","status-publish","format-standard","hentry","category-operatingsystem","category-oracle","category-osx-operatingsystem","category-tipsntricks","category-unix","category-windows","tag-converting","tag-endianness-big","tag-endianness-little","tag-exp","tag-imp","tag-oracle","tag-plattform","tag-rman","tag-transportable-tablespaces"],"_links":{"self":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts\/210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=210"}],"version-history":[{"count":9,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts\/210\/revisions"}],"predecessor-version":[{"id":360,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts\/210\/revisions\/360"}],"wp:attachment":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\n 1 Solaris[tm] OE (32-bit) Big
\n 2 Solaris[tm] OE (64-bit) Big
\n 7 Microsoft Windows NT Little
\n 10 Linux IA (32-bit) Little
\n 6 AIX-Based Systems (64-bit) Big
\n 3 HP-UX (64-bit) Big
\n 5 HP Tru64 UNIX Little
\n 4 HP-UX IA (64-bit) Big
\n 11 Linux IA (64-bit) Little
\n 15 HP Open VMS Little
\n 8 Microsoft Windows IA (64-bit) Little
\n 9 IBM zSeries Based Linux Big
\n 13 Linux 64-bit for AMD Little
\n 16 Apple Mac OS Big
\n 12 Microsoft Windows 64-bit for AMD Little<\/font><\/em><\/p>\n
\nTablespace altered.<\/em> <\/p>\n
\ntablespaces=users
\nfile=users_tts.dmp log=exp_users_tts.log
\nstatistics=none<\/em><\/p>\n
\nconnected to target database: orav10 (DBID=1953618181)<\/em><\/p>\n
\n2> to platform=”Linux IA (32-bit)”
\n3> db_file_name_convert=’\/database\/orav10\/datafiles\/users.dbf’,
\n4> ‘\/tmp\/users.dbf’;<\/em><\/p>\n
\nor \/tmp\/users.dbf<\/em> (converted file if conversion had been required)<\/p>\n
\ndatafiles=<\/em>\/database\/orav10\/datafiles\/users.dbf
\n(or <\/em>\/tmp\/users.dbf )
\nfile=users_tts.dmp log=imp_users_tts.log<\/em><\/p>\n
\nTablespace altered.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"