Router Unable to load some websites and download apps from Google Play


After buying new ZAIN router (Saudi mobile company)  , I found that some sites does not open like portal.elm.sa/



So I found trouble was belongs to Router Firewall .



Disabling Firewall fixes it.











ORA-02298 Parent Keys Not Found


After you export DB then import it you may get this error:













That means a value found in child table but not found in parent table.



You can solve it by the following script to get the values not found :



select <COLUMN_NAME> from <CHILD_TABLE> a where not exists (select <COLUMN_NAME> from



<PARENT_TABLE> where primary_key = a.<KEY_VALUE>);





To looks like :






Then you will get different values and insert them into parent table  or delete them from child table.





Thanks to Atlassian Documentation

Remove unused Layouts in Oracle Apex

 Tables used : APEX_XXXXXXX.WWV_FLOW_REPORT_LAYOUTS APEX_XXXXXXX.WWV_FLOW_SHARED_QUERIES use the following query to delete unused Layouts. ...