Implements the parsing of the actual functions of Oracle transmission tablespace

Do you know how to quickly implement the actual functions of Oracle tablespace transmission? We have previously introduced how to correctly create an Oracle tablespace. Here we will introduce the Oracle tablespace transfer function, it is used to move tablespaces and data files in one instance to another instance.

It is convenient and quick to execute. However, there are some restrictions on using this function:

The two platforms must be consistent. Must have the same character set and multi-language character set. The size of the db block of the two instances must be equal. If the two instances are not equal, the database block must be compatible with the database block of more than 9.0.

The procedure is as follows:

 
 

  
  
SQL> alter tablespace example read only; Tablespace altered SQL>  
 
 

Example tablespace Test

SQL> connect sys/system as sysdba Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 Connected as sys SQL> execute dbms_tts.transport_set_check ('example ', TRUE ); PL/SQL procedure successfully completed SQL> SELECT * FROM TRANSPORT_SET_VIOLATIONS; violations SQL>

If records can be found in the preceding query, it indicates that the table space transfer conditions are not suitable.

SQL>

Move the object to another tablespace;

SQL>

Connect to: Oracle Database 10g Enterprise Edition Release 10. 1. 0. 2. 0-Production With the Partitioning, OLAP and Data Mining options the ZHS16GBK Character Set and AL16UTF16 NCHAR character set have been exported

Note: No table data (rows) will be exported. You can transmit tablespace metadata in Oracle... For tablespace EXAMPLE...

. Exporting cluster Definition

. Exporting table definition...

. Exporting table REGIONS

. Exporting the COUNTRIES table.

. Exporting table LOCATIONS

. Exporting table orders.

. Exporting table JOBS

. Exporting table EMPLOYEES

. Exporting table JOB_HISTORY

Exporting table MERs

Exporting table WAREHOUSES

. Exporting table ORDER_ITEMS

. Exporting table ORDERS

. Exporting table INVENTORIES

. Exporting table PRODUCT_INFORMATION

. Exporting table PRODUCT_DESCRIPTIONS

. Exporting table PROMOTIONS

. Exporting table ORDERS_QUEUETABLE

. Exporting the table AQ $ _ ORDERS_QUEUETABLE_S.

. Exporting the table AQ $ _ ORDERS_QUEUETABLE_T.

. Exporting the table AQ $ _ ORDERS_QUEUETABLE_H.

. Exporting the table AQ $ _ ORDERS_QUEUETABLE_G.

. Exporting table AQ $ _ ORDERS_QUEUETABLE_ I

. Exporting table STREAMS_QUEUE_TABLE

. Exporting table AQ $ _ STREAMS_QUEUE_TABLE_S

. Exporting table AQ $ _ STREAMS_QUEUE_TABLE_T

. Exporting table AQ $ _ STREAMS_QUEUE_TABLE_H

. Exporting table AQ $ _ STREAMS_QUEUE_TABLE_G

. Exporting table AQ $ _ STREAMS_QUEUE_TABLE_ I

. Exporting table TIMES

. Exporting table PRODUCTS

. Exporting table CHANNELS

. Exporting table PROMOTIONS

Exporting table MERs

. Exporting the COUNTRIES table.

. Exporting the SUPPLEMENTARY_DEMOGRAPHICS table.

. Exporting the table CAL_MONTH_SALES_MV.

. Exporting table FWEEK_PSCAT_SALES_MV

. Exporting table SALES

. Exporting table COSTS

. Exporting table MVIEW $ _ EXCEPTIONS

. Exporting table ONLINE_MEDIA

. Exporting the table PRINT_MEDIA

. The reference integrity constraints are being exported.

. Exporting trigger...

. End exporting the tablespace metadata that can be transmitted in Oracle

The export is successfully terminated without a warning.