Skip to Content
author's profile photo Former Member
Former Member

SAPDATA file is full.

Hi Basis Gurus,

I have doubts regarding SAPDATA files

1. What do we need to do if the SAPDATA files ( for example sapdata7 and sapdata8 ) are full.

( My environment is Oracle and Win2k )

2. What are the important SAPDATA files?

3. Is every SAPDATA file important or only the first few are important?

Can you please throw some light on these questions.

Thanks in Advance,

Sachin.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 29, 2008 at 04:40 AM

    Dear Sachin u mentioned the database and the operating system, please mention the SAP version also,

    sapdata directories contain the Oracle data files that make up the Oracle tablespaces. These are the files that contain the actual R/3 data. By default, depending on the SAP release, the system needs five or six sapdata directories. You can create more at your installation convenience & your hierachy.

    This can be the crucial factor for a successful installation and for avoiding performance problems. The configuration and distribution of disks will impact such important aspects of the installation as the data security, performance, application server distribution, and growth estimates.

    All the datafiles are important,

    You have to mention which datafiles are the transactional data (i.e ur daily user data), and the index data files, Better to maintain in different disks for transactional data, index data, temp data To reduce the performance issues,

    With Regards

    Bhaskar

    Edited by: bhaskar1818 on May 29, 2008 10:10 AM

    Edited by: bhaskar1818 on May 29, 2008 10:11 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2008 at 09:01 AM

    hi,

    you need to create a new directory, eg. sapdata9

    create new datafile located on that directory (you can using oracle script, brtools or 3rd party software to create datafile)

    note that every datafile is very very important, because on that file your data is stored.

    rgds,

    alfonsus guritno

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jitender,

      You can increase datafile through brtools in GB also. Kindly note that we can not delete any file or folder in sap.

      Also you can increase instead of GB in MB also. If you wants to in MB then you can select specified mb in brtools.

      Regards,

      Anil

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2008 at 05:42 AM

    Check the DB02--Database performance

    Check the free space statistics,

    we can see the tablespace information, free spaces, Fragments, next Extents, Free extents and the critical objects,

    Accordingly to the space filled, add the datafile using sapdb tools.

    With Regards

    Bhaskar

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.