Topic: Oracle Programming
Download (121) times
Last Download at Monday 23rd of April 2012 12:15:38 AM
Migrating Oracle Database 10 G from Sun Servers to Dell Servers
T o improve the process of migrating data from one database to another or from one platform to another, two key Oracle tools for data migration Data Pump and Transportable Tablespaces were enhanced in Oracle Database 10 g . Data Pump is an improved version of the Oracle Import and Oracle Export utilities from previous versions of Oracle Database. The improvements are designed to add capabilities and decrease the time required for exporting and importing Oracle Database 10 g data.
Using Data Pump to prepare the migration Data Pump export and Data Pump import are additional utilities in Oracle Database 10 g, g g but have a similar look-and-feel to the original export and import utilities. Data Pump export is a utility f for unloading data and metadata from the database into a set of operating system files called dump file sets. A dump file set can be moved to another system and loaded by the Data Pump import utility. Data Pump import is used to load the metadata and data stored in an export dump file set into the database on the target system.
The migration of the database using the Data Pump export and Data Pump import tools comprises three steps: export the data into a dump file on the source server with the expdp command; copy or move the dump file to the target server; and import the dump file into Oracle on the target server by using the impdp command.
The Data Pump export command ( expdp ) is used to export the data. Data Pump import and export require that the location of the dump file be specified via a database directory object. The directory object data_pump_dir must be created on both the source and target systems before running the export or import command from a SQL* Plus session.
Source: www.dell.com
Related PDF Files
Comments for Migrating Oracle Database 10 G from Sun Servers to Dell Servers