ORA-31466: no publications found [message #166037] |
Tue, 04 April 2006 03:38 |
dash_ajit
Messages: 1 Registered: April 2006
|
Junior Member |
|
|
When I execute
BEGIN
DBMS_CDC_SUBSCRIBE.SUBSCRIBE(
subscription_name => 'C1_SUB',
source_schema => 'R1',
source_table => 'C1啊',
column_list => 'COL1埃, COL2唉',
subscriber_view => 'C1_VIEW');
END;
with chinese characters in table name and column name against
Oracle 10.2.0.1.0 database
I got following error
<ORA-31466: no publications found
ORA-06512: at "SYS.DBMS_CDC_ISUBSCRIBE", line 10
ORA-06512: at "SYS.DBMS_CDC_SUBSCRIBE", line 135
ORA-06512: at line 1
I have set NLS_LANG to
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
If I use American English Characters, There is absolutely no issue.
What is the problem?
|
|
|