Re: table move changes rowids?

From: W. Breitling <breitliw_at_centrexcc.com>
Date: 17 Nov 2003 07:47:24 -0800
Message-ID: <22165e0a.0311170747.610e1bff@posting.google.com>

To be precise, indexes are not 'INVALID' after an "alter table ... move" of the underlying table, they are 'UNUSABLE'

"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message news:<vrfin9g9l1mt08_at_corp.supernews.com>...
> Check the status of the indexes after the MOVE.
> You will see that they are invalid.
> You will either need to rebuild them, or drop and recreate them.
>
Received on Mon Nov 17 2003 - 09:47:24 CST

This message: [ Message body ]
Next message: Tony: "Re: index is not used when exists clause is used"
Previous message: Scott Mattes: "Re: how do i know the list of procedure of a package"
In reply to: Steve Ashmore: "Re: table move changes rowids?"
Next in thread: Michael J. Moore: "Re: table move changes rowids?"
Reply: Michael J. Moore: "Re: table move changes rowids?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US