Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Clean up all objects in a tablespace or clean up all objects owned by a user
you can use the DESTROY=Y flag with your import to blow away the
contents of the tablespace and overwrite the existing datafile.
In article <7kodct$j98_at_ustsu10.ust.hk>,
"Yat-Fan" <fan.ho_at_alumni.ust.hk> wrote:
> Hi all,
>
> When I try to rebuild a DB thru' full database import, I usually drop
all
> the tablespaces including their
> contents, rebuild the "empty" tablespaces and then do the importing.
>
> However, the tablespaces are large, this is very time-consuming. Do
anyone
> got one clean script
> which can select out all the objects of a user or a tablespace and
then
> clean them up.
>
> Using select statements, it is not difficult to do this job in
multiple
> phrases, but I am very lazy
> and in case someone already get such a script :-p
>
> Thanks.
>
> Rgds., fan.
> ps. If possible, please also cc: a copy of your reply to me at
> fan.ho_at_alumni.ust.hk
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jun 22 1999 - 13:45:37 CDT