DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: drop all the tables

  1. #1
    Join Date
    Aug 2003
    Location
    Lucknow
    Posts
    8

    drop all the tables

    Hi all,

    I want to drop all the tables in a user in single command. i do not
    want to drop user . is it possible. how we can do this.


    thanx in adv

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    spool /tmp/drop_tables.lst
    select 'drop table '||table_name||' cascade;'
    from dba_tables
    where owner='USERNAME';
    spool off

    @/tmp/drop_tables.lst

    Cheers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width