How to Implement the Oracle tablespace Transfer Function"

In the previous article, we introduced the actual operation steps for creating Oracle tablespace. Today we will introduce the Oracle tablespace transfer function. This article mainly describes how to list instances, table space and data files are moved 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 tablespace transfer conditions are not suitable,

You need to move the object to another tablespace based on the actual SQL> -- situation;

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:

Table data (rows) will not be exported. You can export 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.