4 Replies Latest reply: Aug 18, 2010 11:44 AM by Harish Shetty RSS

SAP database import export

Harish Shetty
Currently Being Moderated

Hi Gurus

My R3 database is 1.8 TB and the no. of datafiles are around 188, all are of 10GB each , how i can minimise the no.of datafiles and reorg the entire database., will it help in reducing the current database size.

  • Re: SAP database import export
    Josef Bodenschatz
    Currently Being Moderated

    Why do you want to minimise the no.of datafiles and reorg the entire database ?

    If there aren't any problems, it will not be worth the effort.

    And I have seen databases with even more datafiles, running smoothly.

     

    And by the way, there may be size limits for files in your operating system. You didn't tell us which.

     

    A reorg may or may not help in reducing the current database size.

    You will know afterwards. It will be not easy to tell in advance.

     

    regards

Actions