Home » SQL & PL/SQL » SQL & PL/SQL » Todd Barry - i know you can help me...
Todd Barry - i know you can help me... [message #21108] Fri, 12 July 2002 10:32 Go to next message
Murali
Messages: 54
Registered: December 1999
Member
please tell me why i am kicked out of my sql session when i say ;desc sometable'.
Same thing happens when i use set pause on and execute any sql commands.
Help is highly appreciated.

Thanks in advance

Report message to a moderator

Re: Todd Barry - i know you can help me... [message #21110 is a reply to message #21108] Fri, 12 July 2002 11:11 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Well, I couldn't answer your other post (same question with a different name - please don't do that on this board) because there is not nearly enough information provided. It sounds though like there is some internal corruption in your database or data dictionary.

Report message to a moderator

Re: Todd Barry - i know you can help me... [message #21114 is a reply to message #21108] Fri, 12 July 2002 23:18 Go to previous message
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
If you suspect your data dictionary corruption then try this..
conn with some other user and give the same command, if the problem persists then take full export of your database and run catalog.sql again.

HTH.

ManishM.

Report message to a moderator

Previous Topic: help for sql
Next Topic: a script to export table to a sql file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 13:55:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.