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

what are the subdirectories of usr/sap/sid/jc<00>/?and their significance?

2 Answers   TCS,

---

Describe your last/current company's landscape, similar to what you would find in STMS>Transport Routes.

0 Answers  

---

How to login in to SAP from command level?

2 Answers  

---

How you will do client copy if sap* user is not available at all in your system then how you will do client copy?

1 Answers  

---

AS-IS & TO-BE process, who gets involved?

1 Answers  

---

---

If the program buffer Hit Ration is <98%, then what should be done by the Basis consultant?

3 Answers   IBM,

---

How can a client be locked?

6 Answers  

---

What is rfc connection?

0 Answers  

---

What are the .sca files and their importance?

1 Answers  

---

how to change the owner of a file in unix

3 Answers   iGate,

---

How to transport objects from Production to Development?

0 Answers  

---

While applying support patch or importing DDIC will get stuck what you do?

3 Answers  

---