Dear DBA's,

I have done an analysis of shared quality table names
between the Runs and Luminosity applications.
They have 3 tables with the same name.
At some point in the future (the minute these tables are
loaded in production), the Luminosity tables will
supercede the Runs tables.
In the meantime, we can make the following change
without effecting operations and we will no longer have
a confusing synonym clash in development.

I am requesting that in d0ofdev1, you delete the following
synonyms:
SYNONYM_NAME   TABLE_NAME    TABLE_OWNER
QUAL_FLAGS     QUAL_FLAGS    RUNS
QUAL_GROUPS    QUAL_GROUPS   RUNS
QUAL_USERS     QUAL_USERS    RUNS

This will allow us to use those synonym names to point
to the Luminosity tables of the same name.
The reason we can make this change now is because
the equivalent Runs synonymns do not exist in d0ofprd1
(the production machine).

If there are any objections, please let us know asap.
Thanks,
Elizabeth

-----------------------------------
desc all_synonyms;

SET PAGESIZE 0;
SET LINESIZE 256;

select synonym_name,table_name,TABLE_OWNER
  from all_synonyms
  where synonym_name like '%QUAL_%'
  order by TABLE_OWNER,table_name;

in d0ofdev1:

LBN_QUALITYS                   LBN_QUALITIES                  LUMINOSITY
LBN_QUALITY                    LBN_QUALITIES                  LUMINOSITY
LBN_QUALITIES                  LBN_QUALITIES                  LUMINOSITY
LBN_QUALITY_PARAM              LBN_QUALITY_PARAMS             LUMINOSITY
LBN_QUALITY_PARAMS             LBN_QUALITY_PARAMS             LUMINOSITY
QUAL_FLAG                      QUAL_FLAGS                     LUMINOSITY
QUAL_GROUP                     QUAL_GROUPS                    LUMINOSITY
QUAL_USER                      QUAL_USERS                     LUMINOSITY
V_LUM_LBN_QUALS                V_LUM_LBN_QUAL                 LUMINOSITY
V_LUM_RUN_QUALS                V_LUM_RUN_QUAL                 LUMINOSITY
QUAL_FLAGS                     QUAL_FLAGS                     RUNS
QUAL_GROUPS                    QUAL_GROUPS                    RUNS
QUAL_USERS                     QUAL_USERS                     RUNS
RUN_QUALITY                    RUN_QUALITY                    RUNS
RUN_QUALITY_PARAMS             RUN_QUALITY_PARAMS             RUNS

in d0ofprd1:

RUN_QUALITY                    RUN_QUALITY                    RUNS
RUN_QUALITY_PARAMS             RUN_QUALITY_PARAMS             RUNS
RUN_QUAL_V                     RUN_QUAL_V                     RUNS

select count(*) from QUAL_GROUPS;
-- 8
select count(*) from luminosity.qual_groups;
-- 9
desc all_tables;
select table_name,owner from all_tables
	where table_name like '%QUAL%GROUP%';

select table_name,owner from all_tables
	where owner='RUNS';

select TABLE_NAME,TABLESPACE_NAME,OWNER 
	from all_tables
	where owner='LUMINOSITY';

select INDEX_NAME,TABLE_NAME,TABLESPACE_NAME,OWNER 
	from all_indexes
	where owner='LUMINOSITY';




