Thursday, November 22, 2007

Online Redefinition

I just tried to do online redefinition on one of my tablespaces objects but failed on the first object with the following error:
ORA-00904: "M_ROW$": INVALID IDENTIFIER

According to

Oracle® Database Administrator's Guide
10g Release 2 (10.2)
Part Number B14231-02

If you used rowids for the redefinition and your COMPATIBLE initialization
parameter is set to 10.1 or lower, set to UNUSED the hidden column M_ROW$$
that is now in the redefined table.
ALTER TABLE table_name SET UNUSED (M_ROW$$);
If COMPATIBLE is 10.2 or higher, this hidden column is automatically set to
UNUSED for you when redefinition completes.

But my problem is that i was reorganizing an entire tablespace through enterprise manager
and got this error on output and aborted the job.

I am investigating this issue with oracle support.


1 comment:

  1. Hi,

    I´m having exactely the same problem right now while trying to perform an online reorg on a 10g db.

    Did you or Oracle support had success after all?

    Thanks
    Sebastian

    ReplyDelete