Skip to Content
avatar image
Former Member

Table space Added automatically

Dear All,

I have faced a problem in Adding table space in oracle.Space getting added automatically in PSAPSR3 table.

what will be the problem behind on this issue.

Please advice.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 25, 2013 at 12:48 PM

    Hello Arunkarthick,

    Login to your SAP system, execute tcode DB02 and select the tablespace where you are facing the issue eg: PSAPSR3. There you'll see the datafiles added to the File System. Check the AutoExtend column, if it is "Yes", then the system will automatically add datafiles till it reaches the Max Size as specified during the last datafile addition using BRTOOLS.

    Also, during the addition of datafiles using BRTOOLS, the system will ask you whether you want to specify the next datafile, you can select No, if you don't want to add the next datafile.

    Read the BRTOOLS options carefully, before you proceed with Yes or No. This should help you resolve the issue.

    Regards,

    Riya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2013 at 12:22 PM

    Hi Arun,

    Please check whether you have set the option of File autoextend mode (autoextend) in ON or not for the existing data files.

    regards

    kartik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2013 at 11:43 AM

    Can you please clarify what you are doing ? Are you creating tablespace OR adding datafiles in any tablespace ? are you adding datafiles with AutoExtend ON ?

    And how you are doing this ?

    Also check this document :

    http://scn.sap.com/docs/DOC-29484

    best regards

    ashish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 15, 2013 at 05:47 AM

    hii arun,

    that particular table have auto extend ON, you can check that...

    regards,

    praveen

    Add comment
    10|10000 characters needed characters exceeded