Skip to Content
avatar image
Former Member

Table space conversion from DMTS to LMTS

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 11, 2011 at 12:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded