oracle number(8 0),bring down the number of tablespaces in Oracle 9.2.0.8

Sharon,

We have done a similar exercise on our BW system. The answer to your question is NO, SAP does not care of the actual names as long as SAP has the tablespaces registered in its dictionary. It is a good practice to stick to the standard SAP naming convention for clarity.

We have used brspace to perform online and offline reorgs. The advantage of this process is that it does make changes to SAP dictionary when the change are done and it is important to cross check if the new tablespaces are registered in SAP tables before you start using the system, the change can be done manually using SQL or using SE16 in case brspace skips it.

I have listed important SAP notes to refer for this activity.

Note 646681 - Reorganising tables with BRSPACE

Note 46272 - Implement new data class in technical settings

Note 737598 - New BRSPACE options for control of Reorg and Rebuild

Cheers,

Nisch