Re: Oracle DB Downsizing

[Quoted] Hi Gareth,

Do an export with the compress option and then import onto the new machine.

Regards

Jerry

Gareth Husk wrote:
>
> Hi Folks,
>
> I've been trawling the net all weekend and checked out this group and
> can't find what I need.
>
> I've returned to Oracle after two years elsewhere and I have a set of
> databases that are used in a demo (ie they aren't really going to grow)
> and I need to downsize the databases so we can move them to smaller
> machines.
>
> Hsa anybody got some scripts that will help me automate this process.
>
> Environment: Oracle 7.1+ on Solaris 2.5.1
>
> Many thanks
>
> Gareth
>
> ========
> gareth_at_thaw.demon.co.uk
 

-- 
Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_p3.net 	Opinions are mine not those of ICT Group