general insert into geom

INSERT INTO user_sdo_geom_metadata
    (TABLE_NAME,
     COLUMN_NAME,
     DIMINFO,
     SRID)
  VALUES (
  'spatialTableOrViewName',
  'SHAPE',

(
select diminfo from user_sdo_geom_metadata where table_name = upper('LB_INTERNATIAL_BORDERS_GIS')
)

,
  28191   -- SRID
);
commit;


Update

update user_sdo_geom_metadata
    set DIMINFO=
  (
select diminfo from user_sdo_geom_metadata where table_name = upper('BACKGROUND')
)
where table_name like 'MB_%' or table_name like 'MP_%';