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
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.