(FAQ)帐套备份恢复后，如何判断两个oracle帐套表及表中字段是否存在差异
可通过以下语句，分别查询两个帐套的表及即字段信息，导出后进行对比。 --查询出某个用户下的所有表(其中VT表不需要比较) SELECT owner, object_name FROM dba_objects where object_TYPE = 'TABLE' and owner = 'EAS75' and object_name not like 'VT%' order by object_name; --查询出某个用户下的所有表及字段信息（其中VT表和回收站中的表不需要比较） select owner,table_name,column_name from dba_col_comments where owner = 'EAS75' and table_name not like 'VT%' and table_name not like 'BIN%' order by table_name,column_name;