Skip to Content

Disk Drive getting full containing sapdata

Hii All,

We are using EEC 6.0 windows os, Oracle 11g, on file system data base drive getting full no space remaining to extend table space psapsr3.

other table spaces have free spaces.

can i utilize the free space of other table space(psaptemp has 69 GB free space )..?

is there any way i can merge the new drive to existing drive. its current size is 2TB..?

can i move data files to new drive..? any impact in future..

kindly suggest the best practice.

Thanks

file_system.JPG (29.9 kB)
table_space.JPG (77.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Aug 23, 2016 at 08:46 AM

    Dear Ganesan,

    Thanks for suggestion.

    Its a normal Growth.

    In F Drive 472 GB is free but this drive contain archive storage..

    & our server is not feasible to add new drive. i can make new drive by utilizing 200 GB out of 472 GB.

    Do you have any proper note guide for moving the data files..? if you have kindly share

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2016 at 08:21 AM

    Hi,

    I think, using PSAPTEMP tablespace is not a right option. Instead you can try to move some data files to drive F as I could see nearly 472 GBs free space or to any new disk. You can use BRTOOLS for this data file movement. Database will be shutdown and startup during this move. When you use BRTOOLS for datafile movement, all the move records will be updated in controfile, so there will be no issue when you move datafile to another disk. Apart from this, is the data growth a normal one? If it is the sudden growth, you can try to find out root cause for the sudden data growth.

    Regards,

    Ganesan

    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.