Re: How to reduce oracle database size

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 21 Feb 2000 13:34:00 +0100
Message-ID: <951137215.6181.0.pluto.d4ee154e@news.demon.nl>

Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

<albertpravin_at_my-deja.com> wrote in message news:88r9oo$unf$1_at_nnrp1.deja.com...
> Hello,
>
> need to know how to determine the empty blocks , which are not used,

execute dbms_utility.analyze_schema('<schemaname>','COMPUTE') Note: empty blocks are not necessarily contiguous and this can only be resolved by export import.
The results will appear in the datadictionary

> how i can reduce the size of datafiles,

alter database datafile '<filename>' resize <x> M
> presently the database is growing very rapidy
>

First make sure autoextend is off.
(Top of my head) alter tablespace <tablespace> noextend.

> can i able to export and import a tablespace.

Not directly. However if you confined individual users to individual tablespaces an user export would do equally well. Note the create user statement is not exported.

Otherwise you'll need to generate an export script with sqlplus listing the correct tables.
>
> Thank you, please reply
>
> /Albert
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Feb 21 2000 - 06:34:00 CST