varrays
nested tables
不支持的对象类型有:
user-defined tables and sequences in the sys schema
tables with unsupported datatypes
tables using data segment compression
index-organized tables
确认主数据是否包含不支持的对象可以查询数据字典表dba_logstdby_unsupported:
sql>select distinct owner,table_name from dba_logstdby_unsupported
2> order by owner,table_name;
用以下的方式查看上面所得出的表的字段名和数据类型:
sql> select column_name,data_type from dba_logstdby_unsupported
2> where owner='oe' and table_name = 'customers';
logical standby database会过滤的sql语句为:
alter database
alter session
alter snapshot
alter snapshot log
alter system switch log
create control file
create database
create database link
create pfile from spfile
create schema authorization
create snapshot
create snapshot log
create spfile from pfile
create table as select from a cluster table
