Database Reorganize

[Former Member]

Hi expert

I want to minimize the size of our current production server, so I delete 1 client (unused client)

Now I'm going to do database reorganization with BRTOOLS

my question is what table to reorganize ?

thanks

Della

[former_member227600]

Hi,

If you have delete the client than you have to go for full DB reorg (As suggest by Jaun). I am giving you some idea , how we can reorg DB with BRtolls.

If you go through the SAP Note which has mention by Jaun,than you can find that in oracle 10g we can reorg full DB online.

1:- Reorg Table which do not have LONG field

2:- Convert Long field to LOB field & Reorg Table which have LONG field .

If you need detailed DB reorg steps than go throug the below link.

[I have given detailed steps here|]

Thanks & Regards

Gopal Kaushik

[Former Member]

Hi Karan

thanks a lot for your detail step by step

really appreciate it

But we have to turn off SAP R3 right?

so, I have to schedule itu with my boss

Thanks again

will inform you later after the reorganize successfully done

Thanks

[JPReyes]

With the client deletion you have probably removed entries from most tablespaces... Reorganization is a very time consuming task, I recommend you to read,

SAP Note 541538 - FAQ: Reorganization

SAP Note 646681 - Reorganizing tables with BRSPACE

Regards

Juan

[Former Member]

Hi,

Go with large size tables.

Regards, Rahul.