Difference between adding a data file and resizing the data
file?
Answers were Sorted based on User's Feedback
Answer / sujatha thirumaran
--> Adding a new datafile to the existing Tablespace
--> Resizing the datafile means changing the size of the
existing datafile
Is This Answer Correct ? | 10 Yes | 5 No |
Answer / 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 |
what type of files are created during the export?
How to delet a table in sap. How to move a table from one location to another.
How to do transport's between Production and Development?
Why can't we do it thru some other client?
In operation modes i have schedule some jobs in off peak but the jobs are not completed with in time of off peak what happen at this time whether they wait until jobs complet or change to peak mode ? off peak time interval is from 6.0 pm to 6.0 am and peak time interval is from 6.0 am to 6.0 pm
If the sap system is down where will you start trouble shooting?
What is the importance/need of Virtual system?
Can anyone tell me what is Server and Instance in sap,wat is exact meaning of that?
What Is your landscape
How TRANS (:\usr\sap\trans) directory is configured, what is the maximum size of TRANS directory, how to see? briefly....
In which table failed user login attempts will be there?
can we give one check for all vendors in automatic payment run? how?