Sorry, mean DML.
On 5/16/07, Alexander Fatkulin <afatkulin_at_gmail.com> wrote:
> Sure, you can also try an "online" option - that way you can still
> perform DDL against the table while index is being rebuild.
>
> On 5/16/07, BLock_at_dvfs.com <BLock_at_dvfs.com> wrote:
> >
> > Can I do an Alter Index rebuild to move an index to an index tablespace
> > while the database is up?
> >
> > We are a 24x7 operation with scheduled outages usually only once a month.
> >
> > alter index schema.I_B_OAPREFSETTLEMENTVALUE_1 rebuild
> > tablespace schema_IDX storage ( initial 256 K next 256 K pctincrease 0 ) ;
> >
> > Thanks
> >
> > Brian Lock
> > DBA - East Campus
> >
> >
>
>
> --
> Alexander Fatkulin
>
--
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 15 2007 - 11:17:25 CDT
