Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Truncate Truncate and More Truncate
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