Skip to Content
avatar image
Former Member

Mass deletion of data from Tables/Table spaces

Hi Gurus,

I am on SUN UNIX, SAP 4.7 and Oracle 9

Is there a way to find or pull a report to see from which tables Mass deletion of data happened. Recently I have deletion couple of clients from my QAT and PRD servers and I am planning to reorg the database to compress.

Please give me some guide lines that I need following before reorganizing the DB.

I mean precautions and the procedure to reorg the DB

Thanks a lot in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 13, 2007 at 11:06 AM

    Check

    Note 541538 - FAQ: Reorganisationen

    for tips and tricks (and also see related notes).

    --

    Markus

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 14, 2007 at 07:42 PM

    also read SAP note 646681... and if you can, upgrade to Oracle 10g, it will give you more options such as rename tablespaces.

    Add comment
    10|10000 characters needed characters exceeded