I need some clarification on note 355771 regarding the new tablespace layout in an ABAP only system. At the moment, I am using Oracle 188.8.131.52 with SAP Kernel 6.40 and dictionary managed tablespaces with the old tablespace layout. I am upgrading to Oracle 10.2.0.2 soon and then I am doing a full reorganisation to have ASSM tablespaces and the new tablespace layout implemented. I understand that PSAPUNDO, SYSTEM and PSAPTEMP remain as they were. Also, I need to create the new
tablespaces, which will be ASSM. Then I need to export/import the contents of the tablespaces below to the tablespaces above
What is not clear to me is exactly what goes to where: For example:
Am I exporting the contents of PSAPUSER1D/I and importing them to PSAPSR3USR
Am I exporting the contents of PSAPEL640D/I and PSAPES640D/I and importing them to PSAPSR3640
Am I exporting the contents of all the rest and importing them to PSAPSR3
Is this the way to implement the new tablespace layout? I didn't find exact instructions on what data from the old tablespaces should be imported to each of the new tablespaces.