Home » SQL & PL/SQL » SQL & PL/SQL » How to refresh session in Sql Plus or Toad (Oracle 10g)
How to refresh session in Sql Plus or Toad [message #301760] Thu, 21 February 2008 09:57 Go to next message
vasanthanand
Messages: 3
Registered: February 2008
Junior Member
Hi all,

I am trying to run a test script to test my stored procedure.
But this proc involves lot of Temp tables or Global Temporary tables.

My problem is each and every time i have to log off the active session and again log on inorder to make the Temp tables to get truncated.Wondering any command which can be run via SQL Editor on any Oracle client tools like Toad or Pl/SQL developer.I tried the refresh no use.

I am also getting a ORA-1536 Space quota exceeded for Table Space 'USERS'. so any help will be appreciated.Tried on the DBA side they say everything is normal.

Thanks in Advance
Vasanthanand
Re: How to refresh session in Sql Plus or Toad [message #301763 is a reply to message #301760] Thu, 21 February 2008 10:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ TRUNCATE TABLE is the command to truncate the table, don't need to disconnect. More, if it is a GTT with transaction scope, commit or rollback is sufficient to truncate the table

2/ "Space quota exceeded for Table Space 'USERS'" means you reached the limit that is allocated to you. You either have to truncate/drop some tables or ask your DBA to allocate you more space.

Regards
Michel
Re: How to refresh session in Sql Plus or Toad [message #301764 is a reply to message #301763] Thu, 21 February 2008 10:54 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You could also just re-connect the session with.

connect user/pass@sid


without closing SQL*Plus.

It also works in the SQLTools I use, I don't know if it works in TOAD or PL/SQL Developer.

Previous Topic: aborting DDL within trigger
Next Topic: getting error code ORA-24550
Goto Forum:
  


Current Time: Sun Dec 11 04:18:05 CST 2016

Total time taken to generate the page: 0.03915 seconds