SQL> begin
2 dbms_cdc_publish.create_change_table(
3 owner=>'cdc_publisher',
4 change_set_name=>'person_change_set',
5 source_schema=>'zlhis',
6 source_table=>'person',
7 column_type_list=>'ID number,NAME varchar2(10),sex varchar2(2)',
8 change_table_name=>'person_ct',
9 capture_values=>'both',
10 rs_id=>'y',
11 row_id=>'n',
12 user_id=>'n',
13 timestamp=>'n',
14 object_id=>'n',
15 source_colmap=>'y',
16 target_colmap=>'y',
17 options_string=>'tablespace ts_cdcpub');
18 end;
19 /
PL/SQL procedure successfully completed
SQL> grant select on person_ct to cdc_publisher;
grant select on person_ct to cdc_publisher
ORA-00942: table or view does not exist
这是怎么回事
2 dbms_cdc_publish.create_change_table(
3 owner=>'cdc_publisher',
4 change_set_name=>'person_change_set',
5 source_schema=>'zlhis',
6 source_table=>'person',
7 column_type_list=>'ID number,NAME varchar2(10),sex varchar2(2)',
8 change_table_name=>'person_ct',
9 capture_values=>'both',
10 rs_id=>'y',
11 row_id=>'n',
12 user_id=>'n',
13 timestamp=>'n',
14 object_id=>'n',
15 source_colmap=>'y',
16 target_colmap=>'y',
17 options_string=>'tablespace ts_cdcpub');
18 end;
19 /
PL/SQL procedure successfully completed
SQL> grant select on person_ct to cdc_publisher;
grant select on person_ct to cdc_publisher
ORA-00942: table or view does not exist
这是怎么回事
person_ct 这个表的属主是当前登录用户吗?