Re: IO question

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Sun, 20 Jan 2002 22:09:42 +0000 (UTC)
Message-ID: <a2ff75$9tl$1@knossos.btinternet.com>

"Fergus" <sinhask_at_swbell.net> wrote in message news:oIp28.8144$Lz3.3081275523_at_newssvr30.news.prodigy.com...
> see my 2c below
>
>
> "A Wong" <ajkwong5_at_hotmail.com> wrote in message
> news:_ml28.17299$467.747785_at_news2.calgary.shaw.ca...
> > it's better to have your index on a seperate physical disk than data,
> > correct?

<snip>
> >also, the database is
> > live, so would this take long to do?
>
> Might need some downtime - depending on your how many datafiles you
> actually have and what are their sizes - you can do ground work and write
> scripts beforehand - then all depends on time the datafile copying takes.
>
> If you just wish to move index tablespaces and provided your vendor has
not
> put index and data in same file, you can drop the indexes, drop the
> tablespaces
> and recreate them as per your wish.

If you are running 8i or above then create NEW tablespaces on the new disks and then issue

alter index rebuild online tablespace new_ts; No downtime required.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Sun Jan 20 2002 - 16:09:42 CST