-- E.Gallas Nov 2005
--
-- look at what tables are owned by %CALIB% table owners
-- look at what tables are owned by %MUON% table owners
--
-----------------------------------------------------------------------------------

sqlplus d0read/reader@d0ofprd1

set pagesize 250;

select owner,table_name from all_tables
  	where owner like '%CALIB%'
	order by owner,table_name ;

OWNER                          TABLE_NAME
------------------------------ ------------------------------
CAL_CALIBRATION                CAL_BADS
CAL_CALIBRATION                CAL_BADS_TMP
CAL_CALIBRATION                CAL_CALIBRATIONS
CAL_CALIBRATION                CAL_CALIBRATION_COLLECTIONS
CAL_CALIBRATION                CAL_CALIB_RUNS
CAL_CALIBRATION                CAL_CALIB_RUN_COLLECTIONS
CAL_CALIBRATION                CAL_COLLECTIONS
CAL_CALIBRATION                CAL_CORRECTIONS
CAL_CALIBRATION                CAL_COR_VALUES
CAL_CALIBRATION                CAL_DQ_CHANNELS
CAL_CALIBRATION                CAL_DQ_RUNS
CAL_CALIBRATION                CAL_ERRORS
CAL_CALIBRATION                CAL_EXTRACTIONS
CAL_CALIBRATION                CAL_EXTRACTION_CORRECTIONS
CAL_CALIBRATION                CAL_GAINS
CAL_CALIBRATION                CAL_HARDS
CAL_CALIBRATION                CAL_PEDS
CAL_CALIBRATION                CAL_PED_LIMITS
CAL_CALIBRATION                CAL_PED_LIMITS_TMP
CAL_CALIBRATION                CAL_PED_VALUES
CAL_CALIBRATION                CAL_PUL_CONFIGS
CAL_CALIBRATION                CAL_PUL_SETS
CAL_CALIBRATION                CAL_PUL_VALUES
CAL_CALIBRATION                CAL_TIMES
CFT_CALIB                      CFT_CALIBRATIONS
CFT_CALIB                      CFT_CALIB_COLLECTIONS
CFT_CALIB                      CFT_CALIB_PARAMETERS
CFT_CALIB                      CFT_CALIB_RUNS
CFT_CALIB                      CFT_CALIB_SUBSETS
CFT_CALIB                      CFT_CHANNELS
CFT_CALIB                      CFT_CHANNEL_DETAILS
CFT_CALIB                      CFT_CHANNEL_EFFICIENCIES
CFT_CALIB                      CFT_CH_MAPS
CFT_CALIB                      CFT_GAINS
CFT_CALIB                      CFT_LUMINOSITY_RANGES
CFT_CALIB                      CFT_PEDESTALS
CFT_CALIB                      CFT_TEMP_GAINS
CFT_CALIB                      CFT_TEMP_GAIN_RUNS
CFT_CALIB                      CFT_TEMP_PEDESTALS
CFT_CALIB                      CFT_TEMP_PED_RUNS
CFT_CALIB                      CFT_TEMP_THRESHOLDS
CFT_CALIB                      CFT_TEMP_THRESHOLD_RUNS
CFT_CALIB                      CFT_THRESHOLDS
CFT_CALIB                      CFT_TRANSFER_LOGS
CFT_CALIB                      PLAN_TABLE
CPS_CALIB                      CPS_CALIBRATIONS
CPS_CALIB                      CPS_CALIB_COLLECTIONS
CPS_CALIB                      CPS_CALIB_PARAMETERS
CPS_CALIB                      CPS_CALIB_RUNS
CPS_CALIB                      CPS_CALIB_SUBSETS
CPS_CALIB                      CPS_CHANNEL_ADDRESSES
CPS_CALIB                      CPS_CHANNEL_CONFIGS
CPS_CALIB                      CPS_GAINS
CPS_CALIB                      CPS_LUMINOSITY_RANGES
CPS_CALIB                      CPS_MIPS
CPS_CALIB                      CPS_PEDESTALS
CPS_CALIB                      CPS_TEMP_GAINS
CPS_CALIB                      CPS_TEMP_GAIN_RUNS
CPS_CALIB                      CPS_TEMP_MIPS
CPS_CALIB                      CPS_TEMP_MIP_RUNS
CPS_CALIB                      CPS_TEMP_PEDS
CPS_CALIB                      CPS_TEMP_PED_RUNS
CPS_CALIB                      CPS_TRANSFER_LOGS
FPS_CALIB                      FPS_CALIBRATIONS
FPS_CALIB                      FPS_CALIB_COLLECTIONS
FPS_CALIB                      FPS_CALIB_PARAMETERS
FPS_CALIB                      FPS_CALIB_RUNS
FPS_CALIB                      FPS_CALIB_SUBSETS
FPS_CALIB                      FPS_CHANNEL_ADDRESSES
FPS_CALIB                      FPS_GAINS
FPS_CALIB                      FPS_LUMINOSITY_RANGES
FPS_CALIB                      FPS_MIPS
FPS_CALIB                      FPS_PEDESTALS
FPS_CALIB                      FPS_TEMP_GAINS
FPS_CALIB                      FPS_TEMP_GAIN_RUNS
FPS_CALIB                      FPS_TEMP_MIPS
FPS_CALIB                      FPS_TEMP_MIP_RUNS
FPS_CALIB                      FPS_TEMP_PEDS
FPS_CALIB                      FPS_TEMP_PED_RUNS
FPS_CALIB                      FPS_TRANSFER_LOGS
MUON_MDT_CALIB                 MUON_MDT_ADBS
MUON_MDT_CALIB                 MUON_MDT_ALIS
MUON_MDT_CALIB                 MUON_MDT_ALISETS
MUON_MDT_CALIB                 MUON_MDT_CALS
MUON_MDT_CALIB                 MUON_MDT_CHNS
MUON_MDT_CALIB                 MUON_MDT_MDCS
MUON_MDT_CALIB                 MUON_MDT_MODS
MUON_MDT_CALIB                 MUON_MDT_OCTS
MUON_MDT_CALIB                 MUON_MDT_T0_ADBS
MUON_MDT_CALIB                 MUON_MDT_T0_ADBSETS
MUON_MDT_CALIB                 MUON_MDT_T0_ADB_TMPS
MUON_MDT_CALIB                 MUON_MDT_TRANSFER_LOGS
MUON_MSC_CALIB                 MUON_MSC_CALS
MUON_MSC_CALIB                 MUON_MSC_CHNS
MUON_MSC_CALIB                 MUON_MSC_CRAS
MUON_MSC_CALIB                 MUON_MSC_GAINS
MUON_MSC_CALIB                 MUON_MSC_GAINS_TMP
MUON_MSC_CALIB                 MUON_MSC_LEDS
MUON_MSC_CALIB                 MUON_MSC_LEDS_TMP
MUON_MSC_CALIB                 MUON_MSC_PEDS
MUON_MSC_CALIB                 MUON_MSC_PEDS_TMP
MUON_MSC_CALIB                 MUON_MSC_RUN_SUBSETS
MUON_MSC_CALIB                 MUON_MSC_RUN_SUBSETS_TMP
MUON_MSC_CALIB                 MUON_MSC_SETS
MUON_MSC_CALIB                 MUON_MSC_SET_SUBSET_MAPS
MUON_MSC_CALIB                 MUON_MSC_SFES
MUON_MSC_CALIB                 MUON_MSC_T0_ADJS
MUON_MSC_CALIB                 MUON_MSC_T0_ADJS_TMP
MUON_MSC_CALIB                 MUON_MSC_T0_OFFS
MUON_MSC_CALIB                 MUON_MSC_T0_OFF_SETS
MUON_MSC_CALIB                 MUON_MSC_TRANSFER_LOGS
MUON_PDT_CALIB                 MUON_PDT_ALIS
MUON_PDT_CALIB                 MUON_PDT_ALISETS
MUON_PDT_CALIB                 MUON_PDT_ATDCS
MUON_PDT_CALIB                 MUON_PDT_ATDCSETS
MUON_PDT_CALIB                 MUON_PDT_CALS
MUON_PDT_CALIB                 MUON_PDT_CHNS
MUON_PDT_CALIB                 MUON_PDT_CHNSETS
MUON_PDT_CALIB                 MUON_PDT_CHNSET_RUNSET_MAPS
MUON_PDT_CALIB                 MUON_PDT_DTDCS
MUON_PDT_CALIB                 MUON_PDT_DTDCSETS
MUON_PDT_CALIB                 MUON_PDT_FEBS
MUON_PDT_CALIB                 MUON_PDT_GAINS
MUON_PDT_CALIB                 MUON_PDT_GAINS_TMP
MUON_PDT_CALIB                 MUON_PDT_MODS
MUON_PDT_CALIB                 MUON_PDT_RUNSETS
MUON_PDT_CALIB                 MUON_PDT_RUNSETS_TMP
MUON_PDT_CALIB                 MUON_PDT_T0_CHNS
MUON_PDT_CALIB                 MUON_PDT_T0_CHNS_TMP
MUON_PDT_CALIB                 MUON_PDT_T0_FEBS
MUON_PDT_CALIB                 MUON_PDT_T0_FEBSETS
MUON_PDT_CALIB                 MUON_PDT_T0_MODS
MUON_PDT_CALIB                 MUON_PDT_T0_MODSETS
MUON_PDT_CALIB                 MUON_PDT_TRANSFER_LOG
OFFLINE_CALIBRATION            D0_CALIBRATION_OLD_UPDATES
OFFLINE_CALIBRATION            D0_CALIBRATION_UPDATES
OFFLINE_CALIBRATION            D0_MY_DBIDS
OFFLINE_CALIBRATION            D0_OFFLINE_CALIBRATIONS
OFFLINE_CALIBRATION            D0_OFFLINE_CALIBRATION_SETS
OFFLINE_CALIBRATION            D0_TEST_CALIBRATIONS
SMT_CALIB                      SMT_CALIBRATIONS
SMT_CALIB                      SMT_CAL_SERVER_LOGS
SMT_CALIB                      SMT_CHANNELS
SMT_CALIB                      SMT_CHANNEL_STATUSES
SMT_CALIB                      SMT_COLLECTIONS_LOGS
SMT_CALIB                      SMT_DET_REGIONS
SMT_CALIB                      SMT_DRIFTS
SMT_CALIB                      SMT_DRIFT_CALIBRATIONS
SMT_CALIB                      SMT_DRIFT_COLLECTIONS
SMT_CALIB                      SMT_DRIFT_SETS
SMT_CALIB                      SMT_GAINS
SMT_CALIB                      SMT_GAIN_CALIBRATIONS
SMT_CALIB                      SMT_GAIN_COLLECTIONS
SMT_CALIB                      SMT_GAIN_SETS
SMT_CALIB                      SMT_HDIS
SMT_CALIB                      SMT_LOGS
SMT_CALIB                      SMT_PEDESTALS
SMT_CALIB                      SMT_PED_CALIBRATIONS
SMT_CALIB                      SMT_PED_COLLECTIONS
SMT_CALIB                      SMT_PED_SETS
SMT_CALIB                      SMT_SEQUENCES
SMT_CALIB                      SMT_STAGED_GAINS
SMT_CALIB                      SMT_STAGED_PEDESTALS

163 rows selected.

select owner,table_name from all_tables
  	where owner like '%MUON%'
	order by owner,table_name ;

OWNER                          TABLE_NAME
------------------------------ ------------------------------
MUON_MDT_CALIB                 MUON_MDT_ADBS
MUON_MDT_CALIB                 MUON_MDT_ALIS
MUON_MDT_CALIB                 MUON_MDT_ALISETS
MUON_MDT_CALIB                 MUON_MDT_CALS
MUON_MDT_CALIB                 MUON_MDT_CHNS
MUON_MDT_CALIB                 MUON_MDT_MDCS
MUON_MDT_CALIB                 MUON_MDT_MODS
MUON_MDT_CALIB                 MUON_MDT_OCTS
MUON_MDT_CALIB                 MUON_MDT_T0_ADBS
MUON_MDT_CALIB                 MUON_MDT_T0_ADBSETS
MUON_MDT_CALIB                 MUON_MDT_T0_ADB_TMPS
MUON_MDT_CALIB                 MUON_MDT_TRANSFER_LOGS
MUON_MSC_CALIB                 MUON_MSC_CALS
MUON_MSC_CALIB                 MUON_MSC_CHNS
MUON_MSC_CALIB                 MUON_MSC_CRAS
MUON_MSC_CALIB                 MUON_MSC_GAINS
MUON_MSC_CALIB                 MUON_MSC_GAINS_TMP
MUON_MSC_CALIB                 MUON_MSC_LEDS
MUON_MSC_CALIB                 MUON_MSC_LEDS_TMP
MUON_MSC_CALIB                 MUON_MSC_PEDS
MUON_MSC_CALIB                 MUON_MSC_PEDS_TMP
MUON_MSC_CALIB                 MUON_MSC_RUN_SUBSETS
MUON_MSC_CALIB                 MUON_MSC_RUN_SUBSETS_TMP
MUON_MSC_CALIB                 MUON_MSC_SETS
MUON_MSC_CALIB                 MUON_MSC_SET_SUBSET_MAPS
MUON_MSC_CALIB                 MUON_MSC_SFES
MUON_MSC_CALIB                 MUON_MSC_T0_ADJS
MUON_MSC_CALIB                 MUON_MSC_T0_ADJS_TMP
MUON_MSC_CALIB                 MUON_MSC_T0_OFFS
MUON_MSC_CALIB                 MUON_MSC_T0_OFF_SETS
MUON_MSC_CALIB                 MUON_MSC_TRANSFER_LOGS
MUON_PDT_CALIB                 MUON_PDT_ALIS
MUON_PDT_CALIB                 MUON_PDT_ALISETS
MUON_PDT_CALIB                 MUON_PDT_ATDCS
MUON_PDT_CALIB                 MUON_PDT_ATDCSETS
MUON_PDT_CALIB                 MUON_PDT_CALS
MUON_PDT_CALIB                 MUON_PDT_CHNS
MUON_PDT_CALIB                 MUON_PDT_CHNSETS
MUON_PDT_CALIB                 MUON_PDT_CHNSET_RUNSET_MAPS
MUON_PDT_CALIB                 MUON_PDT_DTDCS
MUON_PDT_CALIB                 MUON_PDT_DTDCSETS
MUON_PDT_CALIB                 MUON_PDT_FEBS
MUON_PDT_CALIB                 MUON_PDT_GAINS
MUON_PDT_CALIB                 MUON_PDT_GAINS_TMP
MUON_PDT_CALIB                 MUON_PDT_MODS
MUON_PDT_CALIB                 MUON_PDT_RUNSETS
MUON_PDT_CALIB                 MUON_PDT_RUNSETS_TMP
MUON_PDT_CALIB                 MUON_PDT_T0_CHNS
MUON_PDT_CALIB                 MUON_PDT_T0_CHNS_TMP
MUON_PDT_CALIB                 MUON_PDT_T0_FEBS
MUON_PDT_CALIB                 MUON_PDT_T0_FEBSETS
MUON_PDT_CALIB                 MUON_PDT_T0_MODS
MUON_PDT_CALIB                 MUON_PDT_T0_MODSETS
MUON_PDT_CALIB                 MUON_PDT_TRANSFER_LOG

54 rows selected.

