SAP DB Reorganisation in SAP 4.6C Kernel 46D Patch 2500 and Oracle 9.2.0.8

[Former Member]

Hi Gurus,

I have to delete the clients and then perform DB-Reorg.

Through SCC5, I am deleting the clients.

1) Is it possible to select all the clients and delte altogether, as there are 12 clients to be deleted.

For Reorg, I went through the below notes :

620803

646681

541538

647697

706625

214995

As I am deleting all clients except 3 (000, 001 and development client), do I need to re-organize the entire database ? How to reorganise the entire database at one go ?

Some of the tables are around 90-98 GB.

Is there any way to check from SAP level (other than SQL query) if the Tablespace is DMTS or LMTS and if it is ASSM ?

Incase of DMTS, do you have any document how to convert to LMTS as I am a bit confused.

Does there any dependency on SAP Kernel Level, is it ok to reorg on Kernel 46D.

Thanks and Regards,

Amit

[JPReyes · Accepted solution]

You can't delete all clients in one go... you need to logon into each and schedule the deletion via SCC5.

A reorg of this scale will be very time consuming.. I think it will be much quicker to do a Homogeneous system copy via Export/Import.

Also, if this is your development system make sure you check the client independent requests that might have been release from those clients and also the version management of developments.

Thats my 2cents.

Regards

Juan

[Former Member · Accepted solution]

Hi Juan,

The system is a homogeneous copy of existing development system. The requirement is to keep only 1 dev client and delete others followed by db-reorg.

Regards,

Amit

[former_member204746 · Accepted solution]

I see that you also posted the same at http://sap.ittoolbox.com/groups/technical-functional/sap-basis/sap-db-reorganisation-in-46c-kernel-4...

[Former Member · Accepted solution]

Yes Eric, I am looking for the valuable inputs, that's why I posted, is it an issue ? shall i not post problems in any other forums other than SDN ?

[former_member204746 · Accepted solution]

there are at least 5 other Basis forums out there.. why not try them all?

[Former Member · Accepted solution]

Eric, I don't know why you are stressing on that. If you can update on the Reorg issue, it would be helpful.

This is BASIS Forum and we need to discuss about BASIS issues not with the one posed by you. Thanks for our understanding.

[former_member204746 · Accepted solution]

you received a reply on ittoolbox, why not update it and ask more questions over there instead of fighting here?

[Former Member · Accepted solution]

I don't know wats your problem. You should stop fighting and avoid making comments which are nowhere relevent to the SAP. Better behave professionally rather being like a kid.

what was the thread and what a mesh you have made. totally out of context, strange whats going in your mind.