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
9172 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

Explain what are the functional modules used in sequence in bdc?

0 Answers

I am having develoment with 3 clients (100,200,300) and in PRD one client(500)after an year i purchased a new machine for quality so i want to import 2 clients (100,200) and in qas but i want the 100 client only sap_user and sap_cust profiles and 200 client sap_all only can i do that in quality any answers plz suggest me

2 Answers IBM, Yash Technologies,

How to increase tables space, resizing, backups and when will you do?

1 Answers

What are the different modules of SAP?

0 Answers EX,

what is ECC ? what is the main difference between ECC and other older verssions of SAP ?

5 Answers

1.why we configure the domain controle in production why sap recommended? 2.what is the use of 001 client?

3 Answers HCL,

EWA configuration?

1 Answers HCL, Wipro, Yash Technologies,

What is redolog file? Path?

0 Answers

How to find sap transaction codes?

2 Answers

What type of security problems you will get?

1 Answers

Hi Folks from SAP world, My name is herald and working in a distribution center. i graduated as an engineer so i got basic knowledge about programming languages. Just basic and very little in fact i almost forgot them but now i realize how important it is today. I am very interested to learn SAP and i actually big fat ZERO on it but i really want to learn. Does anyone want to give an advice how will i start? Please send your advice on my email. i really appreciate you time reading this specially the effort of giving me tips or advices. Cheers!

1 Answers

Explain the process of Logon Load balancing.

1 Answers

For more SAP Basis Interview Questions Click Here