Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to delete all rows in all tables of a schema in Oracle?

737286Nov 26 2009 — edited Nov 27 2009
Hi all,

I want to delete all records of all tables of a schema and I think there should be some statement for this but I don't know how?

may you help?

Edited by: user8105261 on Nov 25, 2009 11:06 PM
This post has been answered by Dird on Nov 26 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2009
Added on Nov 26 2009
17 comments
8,846 views