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
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.
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.
Previous Topic: help for sql
Next Topic: a script to export table to a sql file
Goto Forum:
  


Current Time: Thu Oct 17 04:03:40 CDT 2019