Knowledge Management

Question:
have tried reorging but fails with this error and we lose the contents of all our spools. have tried with brtools, sapdba . When doing a spad consist. check there is an old format of a spool eg: SPOOL1234 where as now is SP00L0001234. We are on oracle 9204 and on 46B, We have upgraded one server so far to ECC5 and of course the problem exists after the upgrade of DEV. We want to fix this problem so that we can make every tablespace locally managed and I only know how to do this via sapdba/reorg and then make it locally managed as part of the process. Any ideas oracle gang for sap.
Answer:
ORA-600's are "usually" Oracle Kernel related errors. Patch upgrade your Oracle to 9.2.0.7.
Cheers
BT
Answer:
and can only be reorganized by using export/import.
Answer:
Off the top of my head....
I remember we had to reorg the TST03 manually using export import (using Oracle tools exp/imp).
I think he Long Raw datatype was breaking the online reorg.
Answer:
thanks everyone, had to get the dba's involved to do this. Brtools (the lastest and SAPDBA on reorgs , export/imports etc couldn't resolve it. Dba's did this manually and we are fine now.
Answer:
Hi ,
Did you use the report RSPO1041?? This should delete a lot of spool records and keep only those which are to be retained.You can make a variant and keep only a few days records
Ankan