Regd: Re-organization of Database after Deletion of Client.

[Former Member]

Dear All,

i have deleted 2 cleints from one of our SAP Server. now i want to re-organize the Data Please proivde the Process for Reorganization of the Database.

Regards

SNB.

[Former Member]

Dear All,

can anyone please guide how to re-organize database after deleting a Client.

Regards

SNB

[Former Member]

Dear All,

thanks for updating the information.

i need in Oracle. and if possible in SQL so that i can go throw that process a;sp.

Regards

SNB

[former_member232051]

Hi Shankar,

Which database are you using. The procedure would be different for all of them.

Sajit

[Former Member]

Hi Shankar,

Refer Note 22941

****Reward points if Helpful*****

Regards

Ganesh

[Former Member]

You have several options, depending on size of the db, tablespace layout and downtime. Additional steps might be required if you have a dualstack installation (ABAP + JAVA).

- use sapinst (r3load based), procedure is layed out in the system copy guide, this will completely recreate your database, is an offline procedure

- do tablespace reorgs with brspace, can be performed online almost completely, see notes below, useful if you have the new tablespace layout, because you probably only have to reorg the PSAPSID tablespace.

- use oracle exp / imp utililties, but only if you are a dba and used to them

I recommend using sapinst, and be sure to have a good backup before you start.

22941 is for informix dbs, does not apply here. Note 541538 holds a general reorg faq. Note 646681 explains reorgs with brspace.

Regards

Michael