...
| No Format | ||
|---|---|---|
| ||
#prepare the tables (we use OFFLINE as neither MINE not APPLY is running; with OFFLINE we won't wait on network timeout) PREPARE OFFLINE SCHEMA OE NODDL ... ... EXCLUDE COLUMN OFFLINE OE.PRODUCT_DESCRIPTIONS.TRANSLATED_NAME EXCLUDE COLUMN OFFLINE OE.PRODUCT_DESCRIPTIONS.XML_DATA |
In this example the columns TRANSLATED_NAME and XML_DATA from the table PRODUCT_DESCRIPTIONS from schema OE are excluded in the replication.
...
| No Format | ||
|---|---|---|
| ||
set verify off
set feedback off
set linesize 100
set pagesize 40000
column thestring format A100
spool exclude_cols.txt
select 'EXCLUDE COLUMN '||d.owner||'.'||d.table_name||'.'||c.column_name thestring
from dba_tab_columns c, dba_tables d
where d.owner = UPPER('&owner')
and d.owner = c.owner
and d.table_name = c.table_name
and c.DATA_TYPE not in (
'NUMBER',
'FLOAT',
'BINARY_FLOAT',
'BINARY_DOUBLE',
'ROWID',
'VARCHAR2',
'VARCHAR',
'CHAR',
'NVARCHAR2',
'NCHAR2NCHAR',
'NCHARNCHAR2',
'DATELONG',
'LONG RAW',
'LONGDATE',
'LONG RAW',
'CLOBBFILE',
'BLOBCLOB',
'LOBBLOB',
'NCLOB')
and data_type not like 'INTERVAL%'
and data_type not like 'TIMESTAMP%'
order by d.owner,d.table_name,c.column_name;
spool off
exit
|
...