OraFAQ Forum: Client Tools » cannot see the view scripts in schema browser

Home » Other » Client Tools » cannot see the view scripts in schema browser (Oracle,10g,windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cannot see the view scripts in schema browser [message #412365]

Wed, 08 July 2009 23:30

sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai

Senior Member

Hi all,

In toad 9.1.0.2,i have view ddl script for all db objects in schema browser excpet view. when i click the view scripts in tab in schema browser ORA-03135 connection lost contact error. but desc <view_name> is working in sqlplus and other tools.

Is any security reason behind it.

please give an advise?

Thanks
michael

Report message to a moderator

Re: cannot see the view scripts in schema browser [message #412374 is a reply to message #412365]

Thu, 09 July 2009 00:34

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Get rid of TOAD.

Regards
Michel

Report message to a moderator

Re: cannot see the view scripts in schema browser [message #412427 is a reply to message #412365]

Thu, 09 July 2009 05:22

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

I'd be asking quest about this - sounds like a bug.

Report message to a moderator

Re: cannot see the view scripts in schema browser [message #412456 is a reply to message #412365]

Thu, 09 July 2009 08:42

thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC

Member

What version db and what version Oracle client are you using?

Also, v9.1 is 2yrs old now. If it was a bug, then it's most definitely been fixed by now.

I'm not remembering this exact problem, so I'm not sure what you're running into.

One thing you can try. Open the SQLMonitor.exe utility that comes free with Toad. Have it watch your Toad/Oracle connection. Grab the sql that causes the 3135. Run that same query from SQL*Plus and see what happens...

Report message to a moderator

Previous Topic:	Difference in precision in sqlplus and excel
Next Topic:	IN PL/sql Deloper not able to debug

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 01:59:29 CDT 2024