Re: alter table move

1.2 GB is not that much. If you estimate your subsystem IO speed with 10 MB/s read and 2 MB/s write performance you should be able to finish within 615 s or about 11 min.

Please consider the following:

1. You cannot "online" move a heap-organized table in 8.1.x, only an IOT. You will receive "ORA-25148: ONLINE option not permitted".
2. You should avoid nologging because either it is an important table so you cannot afford loosing it (you may not be able to recover this table after a restore after a media failure) or it is not important - so why move it?
3. After your move of a heap-organized table you must rebuild your indexes. Calculate this time!

Martin

Krzysztof Kryczka wrote:
>
> ok - if you want detail you can have it:
> handware Dell PowerEdge6400
> OS is Win2000AS
> large for me is:
> sum(bytes) from dba_extents is about 1.2G
> sum(blocks) from dba_extents is about 7000
> any more details?
>
> i have about 4 tables like that and have to reorganize their storage online
>
> > "Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message
> > news:3CC47F8D.CA549024_at_exesolutions.com...
> > > What hardware?
> > > What operating system?
> > > What version of Oracle?
> > > What is 'large'?
> > >
> > > The group's crystal ball is broken today.
> > >
> > > Daniel Morgan
> > >
> > And tomorrow and the day after tomorrow.
> > It might be repaired after a coca cola refill, but then again it will shut
> > itself down at the first FAQ
> >
> > ROFL
> >
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> > to reply remove '-verwijderdit' from my e-mail address
> >
> >
Received on Tue Apr 30 2002 - 10:23:54 CDT