oracle 10g 的数据迁移方案（Data migration scheme for Oracle 10g）.docVIP

oracle 10g 的数据迁移方案（Data migration scheme for Oracle 10g） Data migration scheme for Oracle 10G 3. transfer the file ts1_ts2.dmp to the remote system and place it under the directory /u01/dumps (by file transfer method, such as FTP or RCP). 4. create a directory object in the target database. CREATE DIRECTORY dump_dir AS/u01/dumps; 5. use the data pump import tool to import the file into the database. Impdp lora/lora123 DIRECTORY=dump_dir DUMPFILE=ts1_ts2.dmp If the amount of data in the table space is relatively small, Lora can execute all of the above steps with just one command: Impdp, lora/lora123, DIRECTORY=dump_dir, NETWORK_LINK=srcdb, TABLESPACES= (TS1, TS2) This command uses the data pump import tool to load the data retrieved into the table via the database link SRCDB (discussed in the previous section). However, since network bandwidth is usually limited, this approach may be slower than using an export / transmission / import cycle method. If you just want to transfer a particular table or table collection, Lora can use the TABLES= clause in the expdp command to download only a particular table or table collection. Drag out tablespace As a third option, Lora suggests using the new tool in the Oracle Database 10g, which simplifies the migration of removable table spaces, and therefore involves only a packaging process. In this method, the user tow quot from the source system using the supplied DBMS_STREAMS_TABLESPACE_ADM packet; the tablespace. This packet uses the data pump to transfer the table space and converts the data files into the target system format. It also automatically performs any desired byte order transformation. Heres a procedure for using this approach in the simplest case -- involving a single simple table space (more complicated, introduced in the next section). If a table space has only one data file, this table space is called simple table space. Lora demonstrates how to use the PULL_SIMPLE_TABLESPACE process in the DBMS_STREAMS_TABLESP