Skip to Content
avatar image
Former Member

Getting error/warning while extending Table space

Hello All ,

While extending Table space getting below error , please advise can we extend the same .

BR0280I BRSPACE time stamp: 2013-04-14 16.13.02

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/BRP/sapdata7 for total maximum size of all database files of tablespace PSAPXER located on this disk volume, missing at least 24537.160 MB

BR0280I BRSPACE time stamp: 2013-04-14 16.13.02

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

Note : File system have more space at OS level (26 GB)

/dev/lvBRPsapdata7 204800.00 179232.16  25567.84   88% /oracle/BRP/sapdata7

even i have tried below file system (each file system have nearly 40GB free) , i got the same error/warning .

/dev/lvBRPsapdata10 179200.00 158269.57  20930.43   89% /oracle/BRP/sapdata10

/dev/lvBRPsapdata11 179200.00 142269.61  36930.39   80% /oracle/BRP/sapdata11

/dev/lvBRPsapdata12 179200.00 138269.73  40930.27   78% /oracle/BRP/sapdata12

/dev/lvBRPsapdata13 179200.00 138269.55  40930.45   78% /oracle/BRP/sapdata13

/dev/lvBRPsapdata14 179200.00 138267.83  40932.17   78% /oracle/BRP/sapdata14

/dev/lvBRPsapdata15 179200.00 138268.67  40931.33   78% /oracle/BRP/sapdata15

/dev/lvBRPsapdata16 179200.00 138267.83  40932.17   78% /oracle/BRP/sapdata16

/dev/lvBRPsapdata17 179200.00 138267.80  40932.20   78% /oracle/BRP/sapdata17

Please advise.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 14, 2013 at 02:37 PM

    Hi John,

    Can you please tell me the size of any one datafile present in /sapdata7. I think you are creating the datafile of size 24 GB round.

    How far i can annalyze , it is calculating the next datafile size to be created.

    you can create a 8 GB datafile , and can check it.

    With Regards

    Ashutosh chaturvedi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi John,

      I got the same error when i try to upgrade my BW with BPC system in extending tablespace PSAPTEMP, steps i followed was

      1. Create a new control file by copying the existing control file

      2. use brtools to extend the tablespace and change the autoextend to OFF.

      regards

      karthik

  • avatar image
    Former Member
    Apr 29, 2013 at 05:11 AM

    Hi John,

    what happened? Are you able to find a solution for this? Please keep us posted.

    regards

    karthik

    Add comment
    10|10000 characters needed characters exceeded