Re: Database Compact
From: Rozi & George Goldberger <ghita_at_worldnet.att.net>
Date: Tue, 10 Apr 2001 19:07:47 GMT
Message-ID: <7SIA6.890$zv6.798674_at_typhoon2.ba-dsg.net>
Date: Tue, 10 Apr 2001 19:07:47 GMT
Message-ID: <7SIA6.890$zv6.798674_at_typhoon2.ba-dsg.net>
ALTER TABLESPACE tablespace COALESCE;
If you reefer at the tablespace level.
Although it is done automatically by SMON.
If tablespace is locally managed it will do nothing.
At the table level, save data, truncate table, insert back data.
George
"Tim" <tim_strunk_at_grsinc.com> wrote in message news:9auu9a$25p_at_netaxs.com...
> Does anybody know if there is any way to reduce the white space in oracle
> database after deleting a large amount of data. I would prefer to do this
> without having to create a new blank database and importing a dump file.
>
> Thanks,
> Tim
>
>
Received on Tue Apr 10 2001 - 21:07:47 CEST