Hi,

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 (ajay076@hotmail.com), November 30, 2003

Answers

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 (steve_pratt@isp.state.il.us), August 30, 2004.