create or replace view CMPExternalTable_V ( DeletionParent, AggregatedSignature ,ClassName ,Completed ,CreatedBy ,CreationTimestamp ,CustomerDeletable ,CustomerEditable ,CustomerRenamable ,Description ,Disabled ,Editable ,ElementId ,Frozen ,Generated ,Imported ,LogicalName ,MetadataSignature ,Name ,Note ,NOTM ,Persistent ,Seeded ,StrongTypeName ,UOID ,UpdatedBy ,UpdateTimestamp ,Version ,IconObject ,SoftwareModVersion ,Project ,Prefix ,InstalledModule ,ExternalElementName ,Proxy ,SynonymFor ,ACLContainer ,ValidationResult ,OwningFolder ,AccessParameters ,DefaultLocation ,RefersTo ) as select DeletionParent, d_1 ,s2_1 ,b_1 ,s1_1 ,d_2 ,b_2 ,b_3 ,b_4 ,s3_1 ,b_5 ,b_6 ,i_1 ,b_7 ,b_8 ,b_9 ,s4_1 ,s2_2 ,s2_3 ,s3_2 ,i_2 ,b_10 ,b_11 ,s2_4 ,s2_5 ,s1_2 ,d_3 ,s1_3 ,r_1 ,r_15 ,r_16 ,s1_7 ,r_17 ,s1_8 ,b_13 ,s1_9 ,r_8 ,r_9 ,r_10 ,cl_3 ,r_18 ,r_19 from CMPFCOClasses where s2_1 in ( 'CMPExternalTable' ); create or replace view CMPExternalTable_X ( DeletionParent, AggregatedSignature ,ClassName ,Completed ,CreatedBy ,CreationTimestamp ,CustomerDeletable ,CustomerEditable ,CustomerRenamable ,Description ,Disabled ,Editable ,ElementId ,Frozen ,Generated ,Imported ,LogicalName ,MetadataSignature ,Name ,Note ,NOTM ,Persistent ,Seeded ,StrongTypeName ,UOID ,UpdatedBy ,UpdateTimestamp ,Version ,IconObject ,SoftwareModVersion ,Project ,Prefix ,InstalledModule ,ExternalElementName ,Proxy ,SynonymFor ,ACLContainer ,ValidationResult ,OwningFolder ,AccessParameters ,DefaultLocation ,RefersTo ,CompUOID ,SnapshotID ) as select DeletionParent, d_1 ,s2_1 ,b_1 ,s1_1 ,d_2 ,b_2 ,b_3 ,b_4 ,s3_1 ,b_5 ,b_6 ,i_1 ,b_7 ,b_8 ,b_9 ,s4_1 ,s2_2 ,s2_3 ,s3_2 ,i_2 ,b_10 ,b_11 ,s2_4 ,s2_5 ,s1_2 ,d_3 ,s1_3 ,r_1 ,r_15 ,r_16 ,s1_7 ,r_17 ,s1_8 ,b_13 ,s1_9 ,r_8 ,r_9 ,r_10 ,cl_3 ,r_18 ,r_19 ,CompUOID ,SnapshotID from CMPFCOStorage where active = 0 and s2_1 in ( 'CMPExternalTable' ); create or replace view CMPExternalTable_R ( DeletionParent, AggregatedSignature ,ClassName ,Completed ,CreatedBy ,CreationTimestamp ,CustomerDeletable ,CustomerEditable ,CustomerRenamable ,Description ,Disabled ,Editable ,ElementId ,Frozen ,Generated ,Imported ,LogicalName ,MetadataSignature ,Name ,Note ,NOTM ,Persistent ,Seeded ,StrongTypeName ,UOID ,UpdatedBy ,UpdateTimestamp ,Version ,IconObject ,SoftwareModVersion ,Project ,Prefix ,InstalledModule ,ExternalElementName ,Proxy ,SynonymFor ,ACLContainer ,ValidationResult ,OwningFolder ,AccessParameters ,DefaultLocation ,RefersTo ) as select DeletionParent, d_1 ,s2_1 ,b_1 ,s1_1 ,d_2 ,b_2 ,b_3 ,b_4 ,s3_1 ,b_5 ,b_6 ,i_1 ,b_7 ,b_8 ,b_9 ,s4_1 ,s2_2 ,s2_3 ,s3_2 ,i_2 ,b_10 ,b_11 ,s2_4 ,s2_5 ,s1_2 ,d_3 ,s1_3 ,r_1 ,r_15 ,r_16 ,s1_7 ,r_17 ,s1_8 ,b_13 ,s1_9 ,r_8 ,r_9 ,r_10 ,cl_3 ,r_18 ,r_19 from CMPFCOClasses FCO, FCO_READ_LOOKUP_V l where FCO.i_1=l.fcoId and s2_1 in( 'CMPExternalTable' ); update CMPFCOClasses set cl_3 = s3_4 where s2_1 = 'CMPExternalTable'; update CMPFCOStorage set cl_3 = s3_4 where s2_1 = 'CMPExternalTable'; commit;