Steps to convert Dictionary Managed tablespaces to Locally Managed

[former_member201782]

Hi All,

I am trying to convert two tablespaces from Dictionary Managed to Locally Managed.

Below are the two tablespaces which are dictionary managed:

PSAPROLL

SYSTEM

All other tablespaces are local.

I am following SAP Note 646681 for this conversion.

Our SAP and Oracle Environment:

SAP R/3 4.7 110

Oracle 9.2.0.8

32-bit

I am following below steps:

1. First trying to convert PSAPROLL

2. Created a new tablespace PSAPECC1 with below command

brspace -u / -f tscreate -t PSAPECC1 -s 700M -a yes -m 10000M -i 20M -l {PSAPROLL}

3. Tablespace PSAPECC1 is created.

4. Now trying to do Online reorganization of tables with below command

brspace -u / -f tbreorg -s PSAPROLL -t "*" -n PSAPECC1

I am getting error message 'Table name "*" not found.

I tried removing quotes, adding SAPECC.* as table name. But I get same error message.

Any suggestions or help on this please.

Let me know exact process if I am doing it wrong.

Thanks,

Shrik.

[ACE-SAP · Accepted solution]

Hi

There is no need to migrate PSAPROLL. Create a new Rollback table space with LMTS, create segments in it and drop the old one (segments then tablespace).

By the way you should consider moving to Automtaic Undo Mgt.

The here under note provide detailed procedure:  see section [procedure from MANUAL to AUTO Undo Management]

600141 - Oracle9i: Automatic UNDO Management

Regards

[former_member201782 · Accepted solution]

Hi,

I was able to convert PSAPROLL and SYSTEM to LMTS.

Thanks,

Shrik