Difference between adding a data file and resizing the data
file?

Answer Posted / bhuvesh jindal

By Adding a datafile we mean that we are creating a new Datafile and Resizing is just, resizing your existing datafile. e.g we are datafiles at different drives/mount points, if we want to add datafile of 500m but that mount has just space less than that then instead of going for adding a data-file,  we will resize the existing datafile in that mount to consume that available space and then will re allocate the quota to users, and thus resizing and adding matters upon the condition.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where do you check transport request logs?

850


What are the different types of job status? Can you unschedule an active job?

911


How database extend?

1662


What is the use of patches in sap system? Could you name few common patch types?

937


What are the pre requisite for the SAP Installation?

1817


Hi ,All What is the multi-threading and max connections for rfc. Actually i am facing problem while send large amount of idocs to external system using middle ware tibco r3 adapter. And how to enable these in SAP ?

2144


Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?

819


How to analysis abap dumps?

880


How to define logon groups?

814


What is the difference between st06 and st03?

1616


How you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

1009


Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?

2938


What are common transport errors and their codes?

1712


What is the use of kernel in sap system? How do you check the current kernel version in sap system?

830


When we are doing cash sales, free goods and discount, How many pricing procedure do we need to create..? Only one PP required or have to create multiple PP..? and how many condition type we need to create..?

1085