Table space conversion from DMTS to LMTS

[Former Member]

Hi Techies,

Major part of our table spaces are dictionary managed, We are facing issues with extents very frequetly.

So we are planning to migrage all the table spaces from DMTS to LMTS, where extent management is absolete.

Our DB is Oracle 10.2.0.4

What would be the best approach to perform this converions?

Create a new LM table space and move all the objects from DM to new one?

OR

Migrate all other table spaces from DMTS to LMTS using dbms_space_admin, then migrate SYSTEM tablespace?

If it works what are the post- steps and care to be taken?

Regards,

Nick Loy

[Former Member]

Just gone through the note 646681.

So dbms_space_admin method is not supported by SAP, As per note only the way to migrate is creating a new table space and moving the objects.

Any other solution that can be done online, quickly and with minimum efforts?

Regards,

Nick Loy

[former_member204746]

Hi,

unfortunately, you do not have many options.

possibilities:

1. create TB, reorg online, drop old TB, rename TB

2. export whole DB, drop database, create database, create TBs, import. (Oracle method)

3. export whole DB, install SAP, import. (SAPINST method)

I chose option 1 and reorg'ed everything online. I got back about 40% of DB space in the process.

[volker_borowski2]

Hi,

go to version 11 first, so that you can include OLTP compression in that reorg.

Volker