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
Messages: 59
Registered: September 2006
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.
Re: Can i do this [message #230382 is a reply to message #230380] Wed, 11 April 2007 13:33 Go to previous message
Messages: 817
Registered: December 2005
Senior Member
Use sql to create a sql script and then execute it...

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: Thu Oct 27 02:05:41 CDT 2016

Total time taken to generate the page: 0.10259 seconds