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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain domain controller?

914


TMS Configuration?

1651


Transport request types and its syntax?

2202


describe how SAP handles Memory Management?

860


What is XI3.0? Explain XI

986


How you connect ECC to EP?

1834


Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?

2217


What is the use of patches in sap system? Could you name few common patch types?

952


Have you done any parameter changes using configtool and visual admin tool?

1610


What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?

901


If you have a long-running Job, how do you analyse?

928


Explain the system trace?

874


How database extend?

1689


Can you change the profile parameter in the os level? Which one is advisable why?

1048


How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?

3003