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

Increase size of tablespace

Dear All,

On SAP tcode Db02, say the SIZE of Tablespace PSAPSR3USR is 50 GB and free space is 5 GB. The total size is also 50 GB.

the autoextend is NO. On DB02 - space overview, the free space on database is 200 GB.

Now i want to increase the SIZE of Tablespace PSAPSR3USR from 50 GB to 70 GB, how do I proceed?

If i add 10 GB of datafile using BRTOOLS, will the size of tablespace increase from 50 to 60GB?

Thanks,

Gavisht

MODERATOR: Take time to search before raising a thread.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on May 20, 2015 at 10:41 AM

    Hi,

    You can extend a tablespace by adding data file and you can use TSEXTEND function to do this. You can also check SAP Note 3155, the document SAP Database Guide:Oracle and BRSPACE and the How To Extend Table space on oracle.

    Regards,

    Bíborka

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2015 at 11:34 AM

    Hi Gavisht,

    You increase the tablespace using BRtools. I hope your tablespace total is 50 GB if it so then you have to increase 20 GB, it will added 20GB from the current one and the total will be 70GB and free-space is 25 GB. You can use BRTOOLS adding the data file. kindly follow the below link.

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b0fcbcbf-1a8d-2e10-0885-f4f286e21713?QuickLink=index&…

    Thanks,

    BM

    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.