Unicode Conversion

[Former Member]

Hi,

We are running on R3 Enterprise Ext2 & Oracle 9.2.0.6.At the DB level all the tablespaces are Dictonary Managed(DMT),we are planning to do a reorg which i believe converts tablespace to Local Managed(LMT)as well.

If we want to do a unicode conversion too what is best way to go ahead.

Regards,

etsg

[Former Member]

Hi ETSG,

The unicode conversion is performed by exporting and then importing the database. So the final database is not fragment and no reorganization is needed. When you setup your target system for the unicode, you should select LMTS tablespaces, this is the default if I remember correctly.

If you make a reorganiztion before, it makes no difference for the system after the unicode convertion. The only thing you may gain is a small increase on the export speed, but I dont thing that you will see a big difference

Regards,

Costas

[Former Member]

Dear Costas,

Thanks for the valuable reply,Whether during the UNICODE conversion process we have an option to convert into LMTS? or whether we have to do it upfront?(before the conversion).

Regards,

etsg