Re: How to truncate the data file in a temporary tablespace?

From: Frank van Bortel <fbortel_at_home.nl>
Date: Wed, 04 Jul 2001 08:47:49 GMT
Message-ID: <3B42D845.C8936122@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 Wed Jul 04 2001 - 03:47:49 CDT