Mystery of Describe Command : 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 R.

-- Ajay (, 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 (, August 30, 2004.

Moderation questions? read the FAQ