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

dear friends, HOW TO CONFIGURE INTO ABAP WEB DYNPRO AND ADOBE OF ECC6.0 R/3 IDES SYSTEM?

4035


How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.

3170


How will determine whether your sap server is unicode or ascii ?

666


How to transport objects from Production to Development?

1675


What are the scripts you can create for security by using LSMW??

2247






What is the difference between st06 and st03?

1271


How can you find a list of objects that have been repaired in the system?

728


What is the different type of users in sap?

662


What is GRIR, GRIR effect, why it is imp, How it is analysed, What is expected out GRIR, What is auto write off & Manual GRIR write off?

2632


Using Tc SGEN I have generated 74% job and later I have terminated the job. I wish to start generating from where it stopped I have refreshed but to no chance, nothing was done. How should I further proceed so as to complete the remaining job?

657


I have solman 7.1 Stack3. I want to upgrade to stack13. My question is can I directly download stack13 files from marketplace, if yes, will those files includes xml file ? (MOPZ is not configured in my system).

1368


How to lock or unlock a transaction code using sm01?

1602


How much swap memory should be in the system?

637


What is the difference between asynchronous and synchronous transport?

608


What will you observe in st06?

879