Difference between adding a data file and resizing the data file?

Difference between adding a data file and resizing the data
file?

Question Posted / harsha66940

3 Answers
8319 Views
Span Systems, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Difference between adding a data file and resizing the data file?..

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

Difference between adding a data file and resizing the data file?..

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

Difference between adding a data file and resizing the data file?..

Answer / dj

sujatha thirumaran simply correct answer.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SAP Basis Interview Questions

how to change the owner of a file in unix

3 Answers iGate,

can we transport requests from production to development for client copy using scc8?

3 Answers

In what ways you would know whether a system is unicode or non-unicode?

0 Answers

What is the different type of users in sap?

0 Answers

how do you troubleshoot when user complains that he ii not getting sap portal

4 Answers IBM,

How to move data and cofiles from Sandbox

1 Answers

What is the exact meaning of ASAP?

8 Answers HCL,

Explain what is the purpose of tdevc ?

0 Answers

How are expensive SQL select statements recognized?

5 Answers IBM,

Which table contains the details related to Q defined in SPAM? Is there a way to revert back the Q defined? If yes, How?

0 Answers IBM,

What are common transport errors and their codes?

0 Answers

i am arun, as of now i am working in a power plant. I did B.E mech and have completed PGDC in thermal power plant engineering from NPTI(NATIONAL POWER TRAINING INSTITUTE). I started my career in software oly , as i dono any software languages i got failed in conformation exam. Pls help me , i want to enter software field. in this powerplant field 6 working days for week and holiday is also not sunday, i am not able 2 tc of my family... pls help me how to enter sf fielf. my frds sujjested me 2 try as functional after 2 years. wats the procedure for that... pls pls help me in this issue I have 1 year exp in power plant, i knew mechanical design software. my id : arun0029@gmail.com

0 Answers

For more SAP Basis Interview Questions Click Here