Monday, February 05, 2007

Find tables exsiting in database A but not in database B in the same schema

repadmin@PRDQA> select table_name from dba_tables where owner='PRD'
minus
select table_name from dba_tables@prdp.world where owner='PRD';

TABLE_NAME
------------------------------
AUD$
PRD_AUDIT
PRD_AUDIT_SESSION

repadmin@PRDQA> select table_name from dba_tables@prdp.world where
owner='PRD'
minus
select table_name from dba_tables where owner='PRD';

TABLE_NAME
------------------------------
BK_PRDERAL_STATISTICS

No comments: