Home » SQL & PL/SQL » Client Tools » Describe table (Oracle 9i sqlplus)
Describe table [message #297479] Thu, 31 January 2008 23:07 Go to next message
Messages: 14
Registered: April 2006
Location: Auckland, New Zealand
Junior Member

I am trying to desc a table which I know is existing by querying the user_tables and it has a status of Valid.

The thing is it just hangs and does nothing.
I have tried selecting , truncating , deleting , dropping the table but it just hangs in all the operation.

Is the table gone corrupt.

Can you please tell me how I can overcome this situation.
Re: Describe table [message #297480 is a reply to message #297479] Thu, 31 January 2008 23:09 Go to previous message
Michel Cadot
Messages: 63924
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post your Oracle version (4 decimals, both client and server sides), copy and paste your SQL*Plus session from start to "hang".

Previous Topic: Host String on SQL +
Next Topic: APEX - can't insert/update in an specific schema
Goto Forum:

Current Time: Wed Oct 26 06:40:08 CDT 2016

Total time taken to generate the page: 0.06141 seconds