Generate Create table script from view

[LKBrwn_DBA]

If you create the database link, and supposing the view names are like "{table_name}_VW", then you can use a script like this to report discrepancies:

Select S.Table_Name, S.Column_Name, S.Column_Id
     , S.Data_Length||'<>'||T.Data_Length Data_Length
     , S.Data_Precision||'<>'||T.Data_Precision Data_Precision
     , S.Data_Scale||'<>'||T.Data_Scale Data_Scale
     , S.Nullable||'<>'||T.Nullable Nullable
  From All_Tab_Columns S, All_Tab_Coluns@Target T
Where T.Owner 		= S.Owner  
  And T.Table_Name	= Substr(S.Table_Name,1,Instr(S.Table_Name,'_Vw')-1)
  And T.Column_Id	= S.Column_Id  
  And T.Column_Name	= S.Column_Name  
  And ( 
       S.Data_Length	!= T.Data_Length  
    Or S.Data_Precision	!= T.Data_Precision  
    Or S.Data_Scale 	!= T.Data_Scale  
    Or S.Nullable 	!= T.Nullable );