Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Anybody have experience of online reorg tools ?
Just write a script to generate the commands for you. Then run the
generated commands
spool commands.sql
select ' alter table '||owner||'.'||table_name||'...;' from dba_tables where
ownere not in ('SYS','SYSTEM',...) order by owner, table_name;
spool off
@commands.sql
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Neil Cudd" <neil_at_cudd.demon.co.uk> wrote in message news:190d457f.0305082341.257338a8_at_posting.google.com...Received on Fri May 09 2003 - 07:54:32 CDT
> Hi Antoine,
>
> I appreciate the functions availble, but having a gui/client/server
> tool would still be easier to manage.
> Thanks,
>
> Neil.
>
> "Antoine BRUNEL" <antoinebrunel/yahoo.fr> wrote in message
news:<3ebaf8e0$0$7947$79c14f64_at_nan-newsreader-01.noos.net>...
> > Beginning with 8i, and even mostly with 9i, you are now able to move
objects
> > without altering their availabity:
> >
> > alter table XX move....
> > alter index XXX rebuild ...
> >
> > theses SQL can be parallelized (degree X), nologging.
> >
> > In 92, there are packages specific for online table reorg.
> >
> >
> >
> > "Neil Cudd" <neil_at_cudd.demon.co.uk> a écrit dans le message de
> > news:190d457f.0305081632.4a38cbec_at_posting.google.com...
> > > I'm to make recommendations and was wondering if anybody out there has
> > > experience of an online reorg tools and would care to share their
> > > experiences.
> > >
> > > My platform is primarily 9i 64bit on aix 5.1 - SAP systems.
> > >
> > > Any pointers gratefully received.
> > >
> > > Thanks,
> > >
> > > Neil.