Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Truncate Truncate and More Truncate

Re: Truncate Truncate and More Truncate

From: Mark Gumbs <mgumbs_at_hotmail.com>
Date: Fri, 26 Mar 1999 09:20:40 -0000
Message-ID: <36fb5092.0@145.227.194.253>


I don't think there is a command to do that. However, you can create a script.
Log into the schema.
Type:

select 'Truncate Table ' || table_name ||';' from user_tables;

Spool the output from this query to a file and run the file.

SQL> @filename.sql

HTH Mark



Jobi wrote in message <1FGK2.5026$L66.4866_at_news.rdc1.bc.wave.home.com>...
>Hi,
>
> I just can seem to figure out the SQL to Truncate all the tables that
>belong to a specific Schema!
>
>IE I have one Schema : EricSchema with 50 Tables, How do I truncate them
>in one SQL Command?
>
>
>Thanks,
>
>Eric
>
>
Received on Fri Mar 26 1999 - 03:20:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US