Re: Defragmentation
From: Gerard H. Pille <ghp_at_skynet.be>
Date: 1998/09/18
Message-ID: <01bde2f1$6a350fe0$390120c0_at_GHP.creyfs.be>#1/1
Date: 1998/09/18
Message-ID: <01bde2f1$6a350fe0$390120c0_at_GHP.creyfs.be>#1/1
Export/import is the only sensible way. If space is a problem, I would export to tape on a unix system, I don't know how I would do that on NT though. Recreate your schema with reasonable extents for all tables & indexes, then import with ignore=yes.
"Oracle7 Server Tuning" is good enough to start with, so RTFM, I guess.
-- Kind Regards, Gerard Robert Jungerius <rjungerius_at_death-to-spam.cetecint.com> wrote in article <01bde2d9$a51a8080$270164bf_at_wks139>...Received on Fri Sep 18 1998 - 00:00:00 CEST
> Hello, I'm a Oracle DBA working with Oracle 7.3.4 on the NT4 platform.
> The only way of defragmentation I know of is to export, drop user, create
> user and import.
> This is impossible with databases of 10Gb or more, because the downtime
is
> unacceptable and the
> diskspace needed for this operation is outrageous!
> I'm having serious problems keeping the databases of all customers
running
> smoothly!
>
> How do you defragment a very large database?
> And does anybody have some tips concerning performance tuning?
>
> Thanx in advance.
>
> Robert Jungerius,
> DBA, Software Engineer _at_ CETEC BV
> rjungerius_at_yahoo.com
>