Skip to Content
0
Jul 03, 2007 at 03:00 PM

Question on new tablespace layout

140 Views

Dear all,

I need some clarification on note 355771 regarding the new tablespace layout in an ABAP only system. At the moment, I am using Oracle 9.2.0.7 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

PSAPSR3

PSAPSR3USR

PSAPSR3640

tablespaces, which will be ASSM. Then I need to export/import the contents of the tablespaces below to the tablespaces above

PSAPLOADD/I

PSAPSOURCED/I

PSAPDDICD/I

PSAPPROTD/I

PSAPCLUD/I

PSAPPOOLD/I

PSAPSTABD/I

PSAPBTABD/I

PSAPDOCUD/I

PSAPUSER1D/I

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.

Many thanks

Andreas