17,082
社区成员
发帖
与我相关
我的任务
分享
--比对表的栏位数:
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物件比对我就是这样做的