Automation - MQ Tables --> ORA-10635

[Peter Schrott]

Dear All,

after a reorg with the Tool "Quest - SpaceManager" the automatic Reorg of the MQ Tables no longer works (Version 11.2.3) <-- I disabled the MQ Tables reorg - so I don't become the Error Message

ErrorMessage:

 - U00011889 DB table 'MQ2WP' is going to be reorganized ...
- U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 22bfe80 DB-HDBC: 230ba78
 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
- U00003592 UCUDB - Status: '' Native error: '10635' Msg: 'ORA-10635: Invalid segment or tablespace type
ORA-06512: at "UC4.UC_REORG", line 1
ORA-06512: at line 1'
- U00003594 UCUDB Ret: '3590' opcode: 'EXEC' SQL Stmnt: 'begin UC_Reorg ('MQ2WP'); end;'
- U00003620 Routine 'UCMAIN_R' forces trace because of error.
- U00003450 The TRACE file was opened with the switches '0000000000000001'.

somebody had the same problem?

[Tim Quakulinsky]

Hi,

no we don't have this problem. We also disabled the internal MQ table reorg because of problems in times with high load. We run the statements manually and don't use a tool like "Quest - SpaceManager".

I just google a little bit and found the following article: http://karandba.blogspot.com/2015/05/ora-10635-invalid-segment-or-tablespace.html

Is it possible that SpaceManager compressed the MQ tables? If yes, I suggest to uncompress the tables (--> "alter table <table_name> nocompress;") BUT I am not an DBA nor an Automic support engineer...

Best regards
Tim

------------------------------
Automation Evangelist
Fiducia & GAD IT AG
---
Mitglied des deutschsprachigen Automic-Anwendervereins FOKUS e.V.
Member of the German speaking Automic user association FOKUS e.V.
------------------------------

[Peter Schrott]

Hi Tim,

thanks for the Feedback!

Yes the SpaceManager compressed the table and change also other (securefile etc.). It's also not working after uncompress:(

Kind Regards
Peter