Skip to main content

Search

Welcome to Tibero GTS!

How to Migrate Data at a Specific TSN Point Using table_migrator

Document Type | Technical Information

Category | Migration

Applicable Product Versions | 6FS01, 6FS02, 6FS03, 6FS04, 6FS05, 6FS06, 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS, 5SP1FS01, 5SP1FS02, 5SP1FS03, 5SP1FS04, 5SP1FS06

Document Number | TMITI004

 

Overview

Using table_migrator, you can migrate data at a specific TSN (Time Sequence Number) point.
This guide explains how to use the SELECT_TSN option.
 
 

Method

1. Use the SELECT_TSN option when running migrator.sh or in migrator.properties

Migrate data at tsn(scn) 150000000000000 point.

migrator.sh
            
sh migrator.sh PROPERTY_FILE=migrator.properties SOURCE_SCHEMA=TIBERO
SOURCE_TABLE=TEST1
TARGET_SCHEMA=TIBERO TARGET_TABLE=T1 SELECT_TSN=150000000000000
migrator.properties

#Use TNS(or SCN) option (Optional)

SELECT_TSN=150000000000000

 

2. Check the extracted statement with AS OF TSN(scn) in the migrator log

[Figure 1. Example of statement generated when using the SELECT_TSN option]

 

3. Verify the COUNT of SOURCE and TARGET tables

SOURCE

SQL> SELECT COUNT(*) FROM TIBERO.T1 AS OF SCN 150000000000000;

count(*)
--------------
99
TARGET

SQL> SELECT COUNT(*) FROM TIBERO.T1;

count(*)
--------------
99
Note
  • This option can be used whether the SOURCE DB is TIBERO or ORACLE, and the option is the same: SELECT_TSN.
  • However, if the SOURCE DB is TIBERO, it appears as AS OF TSN, and if ORACLE, it appears as AS OF SCN in the log.

 

 

 

 

Related to