Topic: Oracle Programming
Download (180) times
Last Download at Monday 30th of April 2012 10:43:14 PM
Moving Oracle Databases Across Platforms Without Export/import
The transportable tablespace feature, introduced in Oracle 8i, allows you to copy one or more tablespaces from one database to another. The export and import utilities are used to copy the metadata for the objects residing in the transported tablespaces, and ordinary file copy commands like FTP or SCP are used to copy the actual data files. This feature made sharing information.
In Oracle 8i and Oracle 9i, tablespaces could only be transported into databases that ran on the same hardware platform and operating system. So if your OLTP system ran on HP-UX and your data warehouse on Linux, you could not use transportable tablespaces to copy data efficiently between the databases. And if you had a database running on a Windows server and you wanted to permanently move it to a Sun server running Solaris, you couldn't use transportable tablespaces either.
Beginning in Oracle 10g release 1, cross-platform support for transportable tablespaces is available for several of the most commonly used platforms. The process is similar to transporting tablespaces in previous Oracle releases, except there are a few possible extra steps, and there are more limitations and restrictions. Oracle 10g release 2 goes one step further and offers the ability to transport an entire database across platforms in one step. But the limitations here are even stricter.
This paper focuses on using the cross-platform transportable tablespace feature for moving a database permanently from one platform to another as quickly and efficiently as possible. But this feature could also be used on a regular basis for information sharing between databases running on different platforms. In some cases it may even be possible for multiple databases on different platforms to share the same physical data files in read-only mode. Because you can transport tablespaces into a database running a higher Oracle version, it is theoretically possible that you could upgrade an Oracle 10g release 1 database to Oracle 10g release 2 and move it to a new platform all in one step.
Source: www.dbspecialists.com
Related PDF Files
Comments for Moving Oracle Databases Across Platforms Without Export/import