Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 600
  • Last Modified:

Converting Dictionary Managed Tablespaces into Locally Managed Tablespaces in SAP

Hi,

I have to convert the Dictionary Managed Tablespaces into Locally Managed Tablespaces. Can you please suggest the possible solutions of it in SAP environment.

regards,
- Raj
0
raj_k_s
Asked:
raj_k_s
1 Solution
 
cryptosidCommented:
Hi Raj,

What you are looking for is Reorganization I think.. You can use BR Tools in SAP to do the needful.

You can use table reorganization to:

·        Transform data dictionary managed tablespaces into locally managed tablespaces

·        Transform tablespaces in an old layout – that is, different tablespaces for data and indexes – into tablespaces in the new layout required for Multiple Components in One Database (MCOD), or vice versa

·        Move large tables to a separate tablespace

·        Reorganize tables due to internal or external fragmentation

For more details check the below link.

Reorganization -
http://help.sap.com/saphelp_erp2005/helpdata/en/32/0d0c888839164ba4245b3ff7969c59/frameset.htm

hope that helps.

Regards,
cryptosid
0
 
dann47Commented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: cryptosid

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

Dann47
EE Cleanup Volunteer

0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now