can any body tell how to delete all the tables in a user ata a time
satish.paluvai
-1
Light Poster
Recommended Answers
Jump to Postcan 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 …
All 3 Replies
Memento
2
Light Poster
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'
satish.paluvai
-1
Light Poster
U Have Tried This One? This Is Not Working. All The Tables R Same Like That Only
Memento
2
Light Poster
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.