Code Snippet

Just another Code Snippet site

Random Post :




[Oracle] ORA-01775: looping chain of synonyms

For looped private synonyms, try:

select owner, synonym_name, connect_by_iscycle CYCLE
from dba_synonyms
where connect_by_iscycle > 0
connect by nocycle prior table_owner = owner
and prior table_name = synonym_name; 

To find public synonyms for non existant objects which will generate the looping error as well:

select owner, synonym_name, connect_by_iscycle CYCLE
from dba_synonyms
where connect_by_iscycle > 0
connect by nocycle prior table_name = synonym_name
and prior table_owner = owner
union
select 'PUBLIC', synonym_name, 1
from dba_synonyms
where owner = 'PUBLIC'
and table_name = synonym_name
and (table_name, table_owner) not in (select object_name, owner from dba_objects
where object_type != 'SYNONYM') 

,

[Raspberry] Raspberry Pi / EDF Télé info

http://hallard.me/gestion-de-la-teleinfo-avec-un-raspberry-pi-et-une-carte-arduipi/

https://lhuet.github.io/blog/2014/01/montage-teleinfo.html

http://perso.aquilenet.fr/~sven337/francais/2014/03/09/Suivi-de-consommation-elec-avec-R-Pi.html

http://www.magdiblog.fr/gpio/teleinfo-edf-suivi-conso-de-votre-compteur-electrique/

http://www.chaleurterre.com/forum/viewtopic.php?t=15153

Previous Posts Next posts