Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How much swap memory should be in the system?

1095


What is JVM switch. Why JVM switch is required ?

2606


if i want to limit the condition record validity for forst 10 orders how can i do tht plz ans i hve interview in 2/3 days

2057


How you will give new authorizations?

1838


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

3656


Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

1252


How do you create an instance?

1110


Explain the developer trace?

999


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

1297


How to do transport at OS level?

1961


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

1117


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

1100


Explain segment?

1154


What is Unit Testing in SAP?

1260


Hi, Cansomeone please send the system refresh doc , it's very urgent for me. Thanks in advance.

2363