What is the tablespace?
difference between Offline redolog files and online redolog
files?
Datafiles?
Resizing table space how wil do?
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
Is This Answer Correct ? | 17 Yes | 0 No |
What is a background processing batch scheduler?
AS-IS & TO-BE process, who gets involved?
How to work with Transaction SMLG? How to configure Logon Groups in Application server?
What are the types of transport queries?
How you will do client copy if sap* user is not available at all in your system then how you will do client copy?
Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com
The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?
What is the purpose of table tdevc?
what is logical system ? how to create and why ?
WHAT U WILL DO IF U GOT UPDATE FAILURE IN SM13
How many transport request types are there? Plz Post the Answer if u know thanks & regards Dev
How ORAARCH (:\oracle\DEV\oraarch) directory is configured, what is the maximum size of ORAARCH directory, how to see? briefly....