BW system copy with change of SID

[Former Member]

Hi,

want to create a new system (Oracle) based on a source, but with a change of SID.

Is this possible via the full offline database copy method? Or just via the SAPinst export / import way?

Have got nearly there, but tablespace names contain the SID and there doesn't seem to be a way to rename these on Oracle 9.

Any ideas appreciated.

Andrey

[Former Member · Accepted solution]

Hi,

I would say use the export/import method. Not just because of the change of you tablespaces, but also the owner of these tablespaces sap<sid>. Technically you would probably have no problem, but it is very confusing. Plus, an export/import reorganizes your database, thus improving the performance!

Pascal.

[Former Member]

Please check the following.

It may help.

Kind Regards,

Dimitry