Answer / sujatha thirumaran

--> Adding a new datafile to the existing Tablespace
--> Resizing the datafile means changing the size of the
existing datafile

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.

Answer / dj

sujatha thirumaran simply correct answer.

WHAT U WILL DO IF U GOT UPDATE FAILURE IN SM13

4 Answers  

---

How to add sap systems in solution manager? Steps?

2 Answers  

---

how java instance processes starts?or how java startup and control frame work starts the java instance?

1 Answers   TCS,

---

ecc full form

7 Answers  

---

what are the subdirectories of usr/sap/sid/jc<00>/?and their significance?

2 Answers   TCS,

---

How to know whether a system is Unicode or non Unicode?

9 Answers  

---

While applying support packages, the error Table space overflow is occured? What could be done?

3 Answers  

---

How to check cpu usage in EP?

0 Answers  

---

How to apply java stacks ? expalin step by step prcoess

0 Answers   IBM,

---

How to calculate J2EE Ports?

3 Answers   Birla, IBM, Wipro,

---

Hi , Can any one tell me , How to take back up to local disk . And also tell me where i need to change the parameters to take back up , please give me the list of parameters and appropriate values. Please provide me the steps to take back up.......

2 Answers  

---

Difference between shutdown abort and shutdown immediate?

2 Answers  

---