SQL tricks for the MCAT

• Add uid 102 all(999) access to files
  • insert into mdas_ad_grp_accs select data_grp_id,102,999 from mcat.MDAS_TD_DATA_GRP t1 where t1.data_grp_id like '0002.0009.0001.0001.0001.%%'

• Delete tickets to allow for collection deletion
  • delete from mdas_au_tckt_grp where data_grp_id like '0002.0009.0001.0001%%'

• delete all metadata where filename is 18*TIF
  • delete from mdas_ad_mdata where data_id in (select data_id from mdas_ad_repl where data_name like '18-%.TIF')

-- MikeSmorul - 02 May 2005
to top