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 |
if there are 3 clients in quality(100,200,300) and only two clients in production(100,200) , how many clients will be there after system Refresh ?
Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com
Tell some profile parameter that you have maintained?
How do you do the transports?
What are the table space names that you see in DB02?
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
Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
One user unable to execute one t-code, that is authorization object is missing, How to add this authorization object to user?
What is the difference between Party & Service without party in XI (ID)?
How to change SID?
what is the benefit of tms
how to apply java stacks?