1 服务器迁移后数据量对(表、视图、索引、存储过程、函数、包体)比较
-- (1) 当前用户表总数量新旧差异
SELECT 'xxx' NAME, COUNT(1) C_COUNT, 'TABLE' PROJECT_NAME FROM DBA_OBJECTS T WHERE T.OBJECT_TYPE='TABLE' AND T.OWNER = 'xxx'
MINUS
SELECT 'xxx' NAME, COUNT(1) C_COUNT, 'TABLE' PROJECT_NAME FROM DBA_OBJECTS@DB_LINK T WHERE T.OBJECT_TYPE='TABLE' AND T.OWNER = 'xxx'
-- (2) 当前视图总数量新旧差异
SELECT 'xxx' NAME, COUNT(1) C_COUNT, 'VIEW' PROJECT_NAME FROM DBA_OBJECTS T WHERE T.OBJECT_TYPE='VIEW' AND T.OWNER = 'xxx'
MINUS
SELECT 'xxx' NAME, COUNT(1) C_COUNT, 'VIEW' PROJECT_NAME FROM DBA_OBJECTS@DB_LINK T WHERE T.OBJECT_TYPE='VIEW' AND T.OWNER = 'xxx'
-- (3) 当前存储过程总数量新旧差异
SELECT 'xxx' NAME, COUNT(1) C_COUNT, 'PROCEDURE&