Home » SQL & PL/SQL » SQL & PL/SQL » Procedure to drop all the user tables in the schema .
Procedure to drop all the user tables in the schema . [message #227884] Fri, 30 March 2007 00:45 Go to next message
lokesh.sql
Messages: 9
Registered: November 2006
Location: Pune
Junior Member
Hi All,

May I know how to drop all the user tables in a schema by using the procedure? Please kindly help me out.

Regards,
Lok
Re: Procedure to drop all the user tables in the schema . [message #227885 is a reply to message #227884] Fri, 30 March 2007 00:51 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
same question & solution posted within last two weeks in this forum.
Use SEARCH!
Re: Procedure to drop all the user tables in the schema . [message #227894 is a reply to message #227885] Fri, 30 March 2007 01:32 Go to previous message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

search1

search2

search3


regards
shanth.

[Updated on: Fri, 30 March 2007 01:38]

Report message to a moderator

Previous Topic: IMPLEMENTING COMMIT IN TRIGGERS
Next Topic: login problems in oracle 10g
Goto Forum:
  


Current Time: Thu Dec 08 16:20:33 CST 2016

Total time taken to generate the page: 0.05933 seconds