What is the tablespace?
difference between Offline redolog files and online redolog
files?
Datafiles?
Resizing table space how wil do?
Answer Posted / chandrasekaran
What is tablespace?
It is a logical partition of a database. As the database
are OS datafiles residing in filesystem, to access that we
need a logical definition. That is tablespace
Difference between Offline redolog files and Online redolog
files?
Online redolog file
1. Has the current changes happend in database
2. Used for Instance recovery and database recovery
Offline redolog file
1. It is backup of Online redolog file when online redolog
file is full. Online redolog file are taken backup via
ARCn archive process
2. It is also used for recovery the database when crashed
Datafiles
1. Which carries the actual data
2. Three main types of datafiles are
1. System data files - meta data of entire database
objects
2. Undo data files - Carries un-commited data's
3. User data files - Carries the customized data's
4. Temporary data files - Carries temporary data. used
for sorting
Rezising Tablespace
Three ways to do
1. Extend the current data file in the tablespace
2. Add new datafile to tablesapce
3. set AUTOEXTEND parameter ON
Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What is R/3? and what is basis version?
What is a developer key? and how to generate a developer key?
How you will do that?
How to add authorizations, how you will maintain profiles?
What is the need of having Development system?
What are the daily transactions?
Where can you find a list of object keys included in a transport?
how can we set a/r a/p netting for inter company code transactions? is it possible to do? if yes, give the solution?
What is sap netweaver administrator tool?
Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.
Explain what is the use of reference and service user in sap?
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
While doing implementation do you get any issues?
what is the difference b/w 4.7EE & ECC5.0?
How would you troubleshoot the 'system seems slow'?