i have done it like this to compare the tables in different users.
in this i am getting the columnnames and datatypes not present in table of user2, but after this i want know how to alter the table of user2 using dif table.........
CREATE TABLE DIF AS
(
select
column_name , data_type, data_length, data_scale, data_precision, column_id
from
all_tab_columns
where
table_name = 'tablename'
and owner = 'user1'
minus
select
column_name , data_type, data_length, data_scale, data_precision, column_id
from
all_tab_columns
where
table_name = 'tablename'
and owner = 'user2');