...
| No Format |
|---|
|
set verify 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',
'VARCHAR2',
'VARCHAR',
'CHAR',
'NVARCHAR2',
'NCHAR2',
'NCHAR',
'DATE',
'RAW',
'LONG',
'LONG RAW',
'CLOB',
'BLOB',
'LOB',
'NCLOB')
order by d.owner,d.table_name,c.column_name;
spool off
exit
|
To view the excluded columns from the replication, run the below SQL.
| Code Block |
|---|
set verify off
set lines 200
set pages 5000
spool exclude_col_list.txt
select u.name owner, o.name tabname, c.name colname, decode(c.mine_out,'Y','included','excluded') column_status
from dbrsobj$ o, dbrscol$ c, dbrsuser$ u
where o.obj_ = c.obj_
and o.owner_ = u.user_
and o.mine_out = 'Y'
and c.mine_out = 'N'
and u.name not like 'DBV%';
spool off
exit |