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


Please Help Members By Posting Answers For Below Questions

What is R/3? and what is basis version?

707


What is a developer key? and how to generate a developer key?

645


How you will do that?

1627


How to add authorizations, how you will maintain profiles?

1562


What is the need of having Development system?

1337






What are the daily transactions?

640


Where can you find a list of object keys included in a transport?

636


how can we set a/r a/p netting for inter company code transactions? is it possible to do? if yes, give the solution?

1994


What is sap netweaver administrator tool?

671


Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.

2206


Explain what is the use of reference and service user in sap?

609


How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.

3173


While doing implementation do you get any issues?

1266


what is the difference b/w 4.7EE & ECC5.0?

1951


How would you troubleshoot the 'system seems slow'?

651