- alter tablespace 'tablespace name' offline normal;
- alter database datafile 'the filename' resize 1000 M;
- alter tablespace 'tablespace name' online;
Frank van Bortel <fbortel_at_home.nl> ñîîáùèë â íîâîñòÿõ
ñëåäóþùåå:3B42D845.C8936122_at_home.nl...
> Dino Hsu wrote:
> >
> > Dear all,
> >
> > One of the data file in a temporary tablespace is extrordinarily big
> > (almost half the database size). I am going to do a physical off-line
> > backup, I need to truncate this data file to a small size. Can anyone
> > tell me how? Thanks in advance.
> >
> > Dino
>
> As you will be stopping the db antway, the easiest would be:
> - stop db
> - start restricted
> - drop temporary ts
> - drop datafile(s)
> - re-create temporary ts
> (- shutdown)
> (- backup)
> --
> Gtrz,
>
> Frank van Bortel
Received on Sat Jul 21 2001 - 16:26:20 CDT
