Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Truncate all tables?

738799Dec 4 2009 — edited Dec 4 2009

Hello!
I need to clear all data on my database, except Oracle XE's default (or required) tables. The intention is to restore a SQL backup. Is there any way to erase de data from the tables I want and truncate it with, let's say... just a few clicks/commands? I really don't want to truncate table by table, it will take more time than I got.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 1 2010

Added on Dec 4 2009

#general-database-discussions

10 comments

1,015 views