A m Z o n e

Allow me to hang and kill your SQL*Plus session

Database: Oracle 8i
Tool : Plus80w
This is not a destructive act, just something you need to know. Connect using Plus80w to a database. Make user that an object with the name of "amar" doesn't exist. Create a public synonym with the name of "amar". Now simply describe the object "amar" and see the after effects.

   On plus80w: 
   sql>connect scott/tiger@db01
   Connected. 

   sql>select object_name from user_objects where object_name = 'AMAR';
   no rows selected.

   sql>create public synonym amar for amar;
   synonym created.

   sql>desc amar

If it is not a feature, then it must be a bug. If a public synonym is created with the same name as the reference object and the reference object is not present, plus80w connected to oracle 8i hangs. The same works perfectly when connected from plus33w. Please note that oracle is supposed to display "Object does not exist." in such cases. Describing tables using db_link also throws error, though this will not hang your session.

      SQL>conn scott/tiger@db01
      connected. 
      sql>desc emp@db02 
      ERROR: 
      ORA-02019: connection description for remote database not found 

      SQL>select count(1) from emp@db02; 
        COUNT(1) 
      __________ 
              14 

Press the Back button of you Browser to go to previous page
Home