Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I adjust the new tablespace and user names when backup/restore is used to carry out a system copy?

April 26, 2017backup carry names restore system tablespace Used user

0

Posted

How can I adjust the new tablespace and user names when backup/restore is used to carry out a system copy?

1 Answer

0

Posted

If the new database layout is used with the user SAP (instead of SAPR3) and tablespace names with an integrated SID, these names remain unchanged after backup/restore is used to carry out a system copy. If, for example, you copy a system with SID PRD to a system with SID DEV, users and tablespaces in DEV have “PRD” in their names instead of “DEV”. This is confusing. This situation is normal, it does not cause any technical problems and, at most, may cause some confusion with regard to administration. However, one possible solution is to define an SID-independent schema ID as described in Note 617444.