Unicode Import and tablespace names

[Former Member]

We have completed our BW upgrade to BI 7.0 and we are planning for Unicode Export/Import shortly.

We have big chunk of tablespace space as free space(nearly 50%), which we would like to plan this way.

All i need is the expert opinion on how SAP treats the new tablespaces.

Our DBA is saying to move all the tables from the standard SAP tablespaces to another tablespace name instead of two prone approach(moving the tables from standard tablespace to another intermediate tablespaces, drop the original sap tablespace and recreate again, then move the tables from the intermediate tablespace).This way he can shrink the free space.

Will it have any impact on our unicode import?

Regards,

VJ

[Former Member · Accepted solution]

Hi Vijay,

While doing export/import itself the database shrink will be done. No need to do it again.

-Hari

[Former Member]

Hi,

Do not move tables and delete the Tablespace. export/import for unicode conversion itself is a reorganization of whole database. Your 50% space will be claim during this processes.

However you also need to consider during Unicode conversion your DB size might get increase, this depends on the code page you select for DB.

Regards,

Sachin Rane.