--

-- 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]