|
have correct storage parameters
--
-- 11/2/98
SELECT ''''alter index '''' || index_name || '''' rebuild ''''
, ''''tablespace INDEXES storage ''''
|| '''' ( initial 256 K next 256 K pctincrease 0 ) ; ''''
FROM all_indexes
WHERE ( tablespace_name != ''''INDEXES''''
OR next_extent != ( 256 * 1024 )
)
AND owner = ''''&OWNER''''
/
7. datatype.sql
--
-- datatype.sql
--
-- To check datatype consistency between two environments
--
-- 11/30/98
SELECT
table_name,
column_name,
data_type,
data_length,
data_precision,
data_scale,
nullable
FROM all_tab_columns -- first environment
WHERE owner = ''''&OWNER''''
MINUS
SELECT
table_name,
column_name,
data_type,
data_length,
data_precision,
data_scale,
nullable
FROM all_tab_columns@&my_db_link -- second environment
WHERE owner = ''''&OWNER2''''
order by table_name, column_name
8. obj_coord.sql
--
-- obj_coord.sql
--
-- To find out any difference in objects between two instances
--
-- 12/08/98
SELECT object_name, object_type
FROM user_objects
MINUS
SELECT object_name, object_type
FROM user_objects@&my_db_link;
?
上一页 [1] [2] [3] [4]
没有相关教程
| 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
