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

how can i decleare select-options in module pool table control?

3553

---

Is it possible to install ecc 5.0 as a test system and not production, without installing solution manager?

987

---

How you can disable the ‘import all’ button on stms for the queues?

1105

---

If brtools is not working how you will add datafile?

2485

---

what are the pros and cons of auto extend of table spaces?

2127

---

How do you check the installed software components and product versions on sap system?

973

---

Is sap a database ?

1044

---

Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?

1043

---

How do you solve oracle archive struck?

1859

---

Can you change the profile parameter in the os level? Which one is advisable why?

1201

---

How to perform a sap-export and import tables in sap from os level?

1239

---

what is the common storage file for oracle ?

2043

---

when ever i try to installed sap ecc6.0 sr2 on single system. it show error on phase import abap "Not all objects are successfully processed. DIAGNOSIS: for details see output file with invalid object invalid_objects.txt and log file object_checker.log . SOLUTION: normally it indicate the data load error but in some special cases( for example if some object were created or loaded externally) you can press ok to continue" here error sentence is complete. pls tell what actual error its? is it kernel file related?

2715

---

Mention the use of personalized tab and parameter tab in user master record?

1132

---

How to apply java stacks ? expalin step by step prcoess

1891

---