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

how can we transport one or two tables in client copy from one client to another client?

1 Answers  

---

what is the difference between system copy and system refresh?

2 Answers  

---

what is the main difference between remote client copy, and client export and import.

9 Answers   Logica CMG, Wipro,

---

Differentiate between synchronous and asynchronous transport

0 Answers  

---

what is the full name of SAP Default user DDIC

8 Answers   DS Group, HCL,

---

WHAT U WILL DO IF U GOT UPDATE FAILURE IN SM13

4 Answers  

---

HOW CAN I DO HOMOGENOUS SYSTEM COPY (ECC5.0)?TELL STEP BY STEP PROCESS?

3 Answers   HCL,

---

Why there should be atleast 2 Dialog Wp per instance?

5 Answers   Satyam,

---

Why is it that Only in SAP-BI / SAP-BW Systems do you have the Profile parameter rdisp/max_wprun_time to be set to a value greater than 600 secs.

1 Answers  

---

production is down and you should up it in 20 min .....what will you do....

5 Answers   Logica CMG,

---

What will happen during the export process?

0 Answers  

---

If java is down how you will do trouble shooting?

2 Answers  

---