--比对表的栏位数: SELECT A.OBJECT_NAME,COUNT(B.COLUMN_NAME) FROM ALL_OBJECTS A,ALL_TAB_COLUMNS B WHERE A.OWNER=B.OWNER AND A.OBJECT_NAME=B.TABLE_NAME AND A.OBJECT_TYPE='TABLE' AND A.OWNER='U1PP' AND B.TABLE_NAME LIKE '_XF000%' GROUP BY A.OBJECT_NAME ORDER BY A.OBJECT_NAME;--比对PK\FK\UK SELECT B.TABLE_NAME,B.CONSTRAINT_TYPE,B.CONSTRAINT_NAME FROM ALL_OBJECTS A,ALL_CONSTRAINTS B WHERE A.OWNER=B.OWNER AND A.OBJECT_NAME=B.TABLE_NAME AND A.OBJECT_TYPE='TABLE' AND A.OWNER='U1PP' AND B.TABLE_NAME LIKE '_XF000%' AND CONSTRAINT_TYPE IN ('P','R','U') ORDER BY A.OBJECT_NAME ;--范围先缩小,然后再看有哪些不同,再具体单独比对--我们新客户建置DB物件比对我就是这样做的
-- 但是我的现在怎么读不出来呢?-- 为什么读不出来?你是怎么操作的?
能再详细一点吗,最好sql语句也说下吧
--比对表的栏位数:
SELECT A.OBJECT_NAME,COUNT(B.COLUMN_NAME) FROM ALL_OBJECTS A,ALL_TAB_COLUMNS B WHERE A.OWNER=B.OWNER AND A.OBJECT_NAME=B.TABLE_NAME AND A.OBJECT_TYPE='TABLE' AND A.OWNER='U1PP' AND B.TABLE_NAME LIKE '_XF000%' GROUP BY A.OBJECT_NAME ORDER BY A.OBJECT_NAME;--比对PK\FK\UK
SELECT B.TABLE_NAME,B.CONSTRAINT_TYPE,B.CONSTRAINT_NAME FROM ALL_OBJECTS A,ALL_CONSTRAINTS B WHERE A.OWNER=B.OWNER AND A.OBJECT_NAME=B.TABLE_NAME AND A.OBJECT_TYPE='TABLE' AND A.OWNER='U1PP' AND B.TABLE_NAME LIKE '_XF000%' AND CONSTRAINT_TYPE IN ('P','R','U') ORDER BY A.OBJECT_NAME ;--范围先缩小,然后再看有哪些不同,再具体单独比对--我们新客户建置DB物件比对我就是这样做的
表结构多不一样,我记得有张视图是记录了表的字段信息,但就算找出来哪些字段没有
我觉得对你作业也不大撒,你还是得一个一个去对..还不如找个对比工具贴出来...呵呵.
纯属个人看法..
2.你的Tnsnames.ora是不是些错了,贴出来看看...