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

Hi I am new in this forum and in this practice. can anyone help me out in finding out how to get training material for SAP CRM 2007.

2246

---

At o.s level where to check for system logs of sap application?

1109

---

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

3707

---

Where do you download trail version of sap ecc, what is sap cal?

1140

---

what is garbage collector. is there any way to set the time to gc?

4396

---

list some common errors faced with jspm while updating java stcks.and solutions.

2654

---

describe how SAP handles Memory Management?

1168

---

What is the importance of table t000?

1174

---

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

1093

---

Can you tell me about the landscape migration to cloud ?

1727

---

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

1420

---

Screenshot document for solution manager installation.

1843

---

How to transport objects from Production to Development?

2218

---

Explain kernel upgrade?

1097

---

What do you understand by transport management in sap basis?

1155

---