Mystery of Describe Commandgreenspun.com : LUSENET : DBAzine : One Thread
I was using one schema say s1 and trying to access tables from other schema say s2 . When i tried the command describe s2.tab1 it showed me the structure of table tab1 in schema2 . When i tried using all_objects the same table was not visible . What might be the reason for this ?
Please guide ..
Thanking you .
-- Ajay (firstname.lastname@example.org), November 30, 2003
try logging on as S2 and do the describe. does it show s2.tab1? does it show S1.tab1? I suspect synonyms to be the culprit. you always have to be careful when two ownders use the same table name.
-- steve pratt (email@example.com), August 30, 2004.