truncate tables in my tablespace
From: <burrell.john_at_yahoo.com>
Date: Thu, 17 Jan 2008 10:50:12 -0800 (PST)
Message-ID: <408cbac6-4d82-4a25-9ae7-49b5c7c4f092@d70g2000hsb.googlegroups.com>
Date: Thu, 17 Jan 2008 10:50:12 -0800 (PST)
Message-ID: <408cbac6-4d82-4a25-9ae7-49b5c7c4f092@d70g2000hsb.googlegroups.com>
Hello,
I want to delete all the data in all the tables in my tablespace.
SQL> select table_name from user_tables;
I can get a list of the tables but I dont want to a
for each table type in
SQL> delete from tablename;
Is there a smart way of doing this?
TIA
J
Received on Thu Jan 17 2008 - 12:50:12 CST