oracle 对比方法

select* from all_tables where table_name in( 'A ', 'B ');
PL/SQL Developer-> Tools--> Compare user objects-->选择一个数据库
spool c:\comparetable.txt; select * from all_tables order by  table_name; spool off;