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
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: 826
Registered: December 2005
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: Forms query
Next Topic: running forms build in 6i using 9iAS
Goto Forum:
  


Current Time: Fri Feb 07 20:53:27 CST 2025