Member Avatar for satish.paluvai

can any body tell how to delete all the tables in a user ata a time

  • 2 Contributors
  • 3 Replies
  • 78 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Memento
Member Avatar for Memento

can any body tell how to delete all the tables in a user ata a time

I have never had to do that so I don't know if there is a built in command to do it. The query below would return all the drop commands you need which you could then run in SQLPLUS. If you were just trying to empty the tables substitute truncate for drop.

SELECT 'DROP '||table_name|| ' \'
  FROM all_tables
 WHERE owner = 'USER TO PURGE'
Member Avatar for satish.paluvai

U Have Tried This One? This Is Not Working. All The Tables R Same Like That Only

Member Avatar for Memento

I don't know what you mean by "All The Tables R Same Like That Only".

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.