--REPERROR (2260, DISCARD)
--REPERROR (942, DISCARD)
map sender.*, target receiver.*;
SHOW PARAMETER NLS_LANGUAGE
SHOW PARAMETER NLS_TERRITORY
SELECT name, value$ from SYS.PROPS$ WHERE name = 'NLS_CHARACTERSET';
SHOW PARAMETER NLS_LENGTH_SEMANTICS
SIMPLIFIED CHINESE
CHINA
NLS_CHARACTERSET AL32UTF8
BYTE
SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
SETENV (NLS_LANG = "SIMPLIFIED CHINESE_CHINA.AL32UTF8")
set NLS_LANG = "SIMPLIFIED CHINESE_CHINA.AL32UTF8"
This is an example in UNIX, using the SETENV parameter in the Oracle GoldenGate parameter file:
测试ddl
CREATE TABLE t1(ID NUMBER(5),
StudentID NUMBER(10),
Name VARCHAR2(100),
Old NUMBER(3),
Stature NUMBER(3,2));
INSERT INTO t1 VALUES(1,20110713,'mfy,32,1.77);
INSERT INTO t1 VALUES(2,20110712,'mfy2',32,1.77);
INSERT INTO t1 VALUES(1,20110711,'mfy1',32,1.77);
desc t1
select * from t1;
create table test_tab_1 (id number,rnd_str varchar2(12));
insert into test_tab_1 values (1,'test_1');
commit;
本文出自 “西西梅丽” 博客