Home » Developer & Programmer » Forms » Can i do this
icon2.gif  Can i do this [message #230380] Wed, 11 April 2007 13:11 Go to next message
chmlaeeque
Messages: 59
Registered: September 2006
Karma: 0
Member
Hay Every1,
can any1 plz tell me that how can i delete all tables of the current user or the any user i want to.
MLA
Re: Can i do this [message #230382 is a reply to message #230380] Wed, 11 April 2007 13:33 Go to previous message
orausern
Messages: 817
Registered: December 2005
Karma: 0
Senior Member
Use sql to create a sql script and then execute it...
like:

set heading off
set pages 1000
set feedback off

spool a.lst
select 'drop table '||table_name||' cascade constraints '||';' from user_tables;
spool off

then execute a.lst

I don't have sql plus now..so this is an approximate script..tweak it as required and it should work.

(& keep a backup to safeguard yourself before deleting Smile )
Previous Topic: problem with webutil
Next Topic: Attach vertical scrollbar for text item
Goto Forum:
  


Current Time: Tue Aug 22 11:50:53 CDT 2017

Total time taken to generate the page: 0.10059 seconds