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 is the use of profile paramater ztta/roll_area?
What is the difference Between Role and Profile
20 Answers Accenture, HCL, REL, TCS,
How to take a sap backup using BRTOOLS explain the procedure? When using BRTOOLS, which backup device, you are used (Drive/tape)?
How to schedule background jobs at OS level?
Tell me two ways to check kernel, tp.exe version?
How many types of work processes are there in sap ?
how to configure jco connection from ep to backend(ECC or bw or crm) systems?
if someone lock standard user such as sap* and ddic in client 800? and client 000 is working fine so how can i log in client 800? is there any other standard user with standard password?
How do you create control file? What is the command?
Explain layers and instances with explain???
how to check if your R3 system is unicode or non-unicode?
Can a Patch be rolled back in ABAP or Java?