Skip to Content
Former Member
Aug 10, 2009 at 11:01 PM

Createtablespace.sql is creating tablespaces in wrong sid



We are in the process of performing system copy of EHP4 for TDMS shell creation using standard system copy process as suggested by sap.

During export while SAPInst asked for Import Migration Directory we provided the export dump of target system ( modified as per TDMS shell creation)

During system copy we are getting the error during create table space phase. SAPinst is creating the tablespace with source system SID. .i.e instead of T02 it is taking P02.

create tablespace P02#USER1D

in nodegroup SAPNODEGRP_T02 pagesize 16k extentsize 8 prefetchsize automatic

no file system caching

Because of that we are getting following error during import phase.

ERROR 2009-08-10 07:24:33.154 [iaxxinscbk.cpp:260]

MDB-01999 Error occured, first error is: <SQL0204N "P02#DDICD" is an undefined name. SQLSTATE=42704>

Please suggest.