Skip to Content
avatar image
Former Member

ORA-01691: unable to extend lob segment SAPSR3DB.SYS_LOB0000060065C00006$$

Hi,

We have an issue in PI. When ever we try to save some object in ESR we are getting brlow error.

"ORA-01691: unable to extend lob segment SAPSR3DB.SYS_LOB0000060065C00006$$ by 8192 in tablespace PSAPSR3DB"

Could some one advise me best way to clean up the database. Its a proto system so we can clean the data by direct method.

Please note that we have archviing and deltion job running.

Could some one please help me in fixing this.

Thank you very much in advance.

Regards,

Prasad.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 04, 2011 at 04:00 PM

    For cleaning up the space used by PI system, please use the Archiving and Deletion for the XML messages:

    http://help.sap.com/saphelp_nwpi71/helpdata/en/0e/80553b4d53273de10000000a114084/frameset.htm

    At database level, please run the database reorganization. You can also extend the lob segment at the database, there are no constraints from PI perspective for doing that.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 04, 2011 at 04:28 PM

    Hi Prasad,

    As said you can go for increasing the tablespace and if you really want to deal with the existing database size then check the sap note 872388 and prefer Switch Deletion process to completely drop the table to free the occupied space in database.

    For more details search in sdn for Database reorganization via Switch Delete.

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded