Re: Optimize Table

On Feb 1, 9:38 am, "news.verizon.net" <kenned..._at_verizon.net> wrote:
> <mansoor..._at_gmail.com> wrote in message
>
> news:3f65d008-6ee3-49d7-95ff-00c20d9dcc53_at_s12g2000prg.googlegroups.com...
>
>
>
> > On Jan 31, 8:35 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> >> On Jan 31, 8:56 am, "news.verizon.net" <kenned..._at_verizon.net> wrote:
>
> >> > <mansoor..._at_gmail.com> wrote in message
>
> >> >news:b31143cc-e006-4b0a-9d21-dc36a2550c3f_at_y5g2000hsf.googlegroups.com...>
> >> >There is command 'Optimize Table' in MySQL. What is the equivalent of
> >> > > this in Oracle?
> >> > > And if none, how to optimize an Oracle (10g) table?
>
> >> > > Thx.
>
> >> > What does optimize table in your sql do?
> >> > Jim
>
> >> Had one decided to use google.com one would have found this:
>
> >>http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
>
> >> wherein the OPTIMIZE TABLE command is explained.  Basically it repairs
> >> split (chained/migrated) rows, compacts free space, repairs indexes
> >> and updates table statistics.  Thus, in 10.2 and later releases, which
> >> create statistics automagically, an
>
> >> alter table <tablename> move;
>
> >> followed by an
>
> >> alter index <indexname> rebuild;
>
> >> would perform similar 'magic'.  Of course the antiquated exp/drop/imp
> >> scenario could still be used to 'optimize' the table.  In either case
> >> the table is unavailable for use during the operation as both products
> >> lock the object for the duration of the process.
>
> >> David Fitzjarrell
>
> > Will the alter table <tablename> move; command work without specifying
> > any tablespace name?
>
> > Also how would you rebuild all the indexes of a table without
> > specifying or knowing the names of indexes.
>
> > I'm searching google but so far haven't found anything.
>
> > Thanks
>
> There are ways but why?  What problem are you trying to solve?
> Jim- Hide quoted text -
>
> - Show quoted text -

I need to convert a MySQL script to ORACLE. It has a "Optimize Table <tablename>" statement in there.
It also has "INSERT IGNORE..." which means it ignores unique key constraints and inserts a row anyway.

Do you know how to implement/convert these in Oracle PL/SQL? If someone is willing to help I could also pay ( for future tasks ) Received on Fri Feb 01 2008 - 01:10:05 CST