search
Docs Home

수행 예제

Table Migrator 유틸리티로 Oracle(Source DB)에서 Tibero(Target DB)로 DBMS 전환을 수행하는 예제입니다.

hashtag
1. 테스트 환경 구성

Oracle에 테스트 Table, 데이터, 접속할 계정을 생성합니다.

--DBTECH 계정에 Tablespace, User, Table, Table Data 생성
SQL> create tablespace DBTECH_TBS
2 datafile 'dbtech_tbs01.dtf' size 50M
3 AUTOEXTEND ON NEXT 20M MAXSIZE 5G
4 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

Tablespace created.

SQL> create user dbtech identified by dbtech
2 default tablespace DBTECH_TBS;

User created.

SQL> grant connect, resource to dbtech;

Grant succeeded.

CONNECT dbtech/dbtech;

SQL> create table board (no number,
2 empno number(4),
3 title varchar(20),
4 contents clob,
5 regdate date default sysdate,
6 hit number default 0)
7 PCTFREE 10
8 INITRANS 2;

Table created.

SQL> INSERT INTO BOARD VALUES
(1, 7369, 'introduction', 'Hello, my name is SMITH.', sysdate, 0);

1 row created.

SQL> INSERT INTO BOARD VALUES
(2, 7499, 'introduction', 'Hello, my name is ALLEN.', sysdate, 0);

1 row created.

SQL> INSERT INTO BOARD VALUES
(3, 7521, 'introduction', 'Hello, my name is WARD.', sysdate, 0);

1 row created.

SQL> INSERT INTO BOARD VALUES
(4, 7566, 'introduction', 'Hello, my name is JONES.', sysdate, 0);

1 row created.

SQL> INSERT INTO BOARD VALUES
(5, 7654, 'introduction', 'Hello, my name is MARTIN.', sysdate, 0);

1 row created.

SQL> commit;

Commit complete.

--Migration할 때 접속할 계정(DBTECH_TEST) 생성
SQL> CONNECT /as sysdba
Connected.

SQL> create user dbtech_test identified by dbtech_test
2 default tablespace DBTECH_TBS;

User created.

--DBTECH_TEST 계정에 권한 부여(connect)
SQL> grant connect to dbtech_test;

Grant succeeded.

--DBTECH_TEST 계정에 Table 조회 권한 부여(select on dbtech.board)
SQL> grant select on dbtech.board to dbtech_test;

Grant succeeded.

--DBTECH_TEST 계정에 권한 부여(select any dictionary)
SQL> grant select any dictionary to dbtech_test;

Grant succeeded.

hashtag

hashtag
2. 전환 수행

Oracle에 테스트 Table, 데이터, 접속할 계정을 생성합니다.

hashtag

Last updated