Ask the Expert

How to introduce a new tablespace structure with an OS/DB migration

When we do an OS/DB migration, how can we introduce the new tablespace structure, eg. psap, as specifed in 6.40?

1. Creating the DB with the new tablespace layout is not an issue.
2. While exporting the data from an old environment (R/3 Enterprise), which has the old tablespace layout, all the files with DBSIZE.TPL and DDLORA.TPL are created with old tablespace reference. How can this be changed while importing, so that it will go to the new TS layouts?

    Requires Free Membership to View

Use the DBSIZE.TPL and DDLORA.TPL templates which come with the standard SAP installation CDs. They reside on the export/language CD. Both templates are ready for the new database layout.

Please note that you will need to add your customized table classes to the standard DDLORA.TPL before the import.

This was first published in November 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: