cancel
Showing results for 
Search instead for 
Did you mean: 

Mass deletion of data from Tables/Table spaces

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member204746
Active Contributor
0 Kudos

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

markus_doehr2
Active Contributor
0 Kudos

Check

Note 541538 - FAQ: Reorganisationen

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

--

Markus