Oracle Table Space Transfer

Oracle Tablespace Transfer is a new addition to 8i, a fast way to move data between databases, by putting a number

The format data file on the library is attached to another database, rather than exporting the data as a DMP file, which

In some cases it works very well because moving data in a table space is as fast as copying a file.

1. There are some rules for transferring table space (10g ago):

· The source and destination databases must be running on the same hardware platform.

[Oracle Backup and Recovery summary] E-mail/msn:db.dw.dm@gmail.com

[Oracle Backup and Recovery summary] E-mail/msn:db.dw.dm@gmail.com

9/84

· The source database and the target database must use the same character set.

· The source database and the target database must have the same size block of data

· The destination database cannot have a table space with the same name as the migrated table space

· SYS object cannot be migrated

· Must transfer self contained set of objects

· Some objects, such as materialized views, function based indexes, etc. cannot be transmitted

(Cross-platform of the same byte-order file can be used to replace the data file header method)

(10g supports Cross-platform table space transfer, as long as the operating system byte order is the same, you can do tablespace

Transmission. Need to use Rman to convert file format, slightly)

2. Method of detecting whether a table space meets the transmission standard:

SQL > Exec sys.dbms_tts.transport_set_check (' Tablespace_name ', true);

SQL > select * from Sys.transport_set_violations;

If there is no row selection, the table space contains only the table data and is self-contained. For some non-self packages

Contains table spaces, such as data table space and index table space, that can be transferred together.

3. Brief use steps:

If you want to refer to the detailed use method, you can also refer to the Oracle DBA online Help.

1. Set table space to read only (assuming tablespace name is App_Data and App_index)

SQL > Alter tablespace app_data read only;

SQL > Alter tablespace app_index read only;