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?
- 1 Answers
- 18954 Views
- I also Faced
- E-Mail Answers
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 sap ides?
What the immediate steps if the instance did not came up after restart in both AS ABAP and AS Java?
As a basis consultant what are the roles and responsibility's looking in to EP(EP monitoring, and trouble shooting and how to connect please let me some thing anybody plz help me)
what is the common storage file for oracle ?
What is Unit Testing in SAP?
Which transport directory is used to implement support package and add-ons?
You want to find out which users have an access to a particulat transaction. How would you do that?
What is the different architecture between SAP 4.7EE & ECC5.0
In what ways you would know whether a system is unicode or non-unicode?
What is Consolidation route and delivery routes? How you will identify them?
How to login in to SAP from command level?
What is Tranport Group & Transport directory in STMS? Briefiely expalin the functionalities?
-
SAP Basis (1262) - SAP ABAP (3939)
- SAPScript (236)
- SAP SD (Sales & Distribution) (2717)
- SAP MM (Material Management) (912)
- SAP QM (Quality Management) (99)
- SAP PP (Production Planning) (523)
- SAP PM (Plant Maintenance) (252)
- SAP PS (Project Systems) (138)
- SAP FI-CO (Financial Accounting & Controlling) (2766)
- SAP HR (Human Resource Management) (1180)
- SAP CRM (Customer Relationship Management) (432)
- SAP SRM (Supplier Relationship Management) (132)
- SAP APO (Advanced Planner Optimizer) (92)
- SAP BW (Business Warehouse) (896)
- SAP Business Workflow (72)
- SAP Security (597)
- SAP Interfaces (74)
- SAP Netweaver (282)
- SAP ALE IDocs (163)
- SAP Business One (110)
- SAP BO BOBJ (Business Objects) (388)
- SAP CPS (Central Process Scheduling) (14)
- SAP GTS (Global Trade Services) (21)
- SAP Hybris (132)
- SAP HANA (700)
- SAP PI (Process Integration) (113)
- SAP PO (Process Orchestration) (25)
- SAP BI (Business Intelligence) (174)
- SAP BPC (Business Planning and Consolidation) (38)
- SAP BODS (Business Objects Data Services) (49)
- SAP BODI (Business Objects Data Integrator) (26)
- SAP Ariba (9)
- SAP Fiori (45)
- SAP EWM (Extended Warehouse Management) (58)
- Sap R/3 (150)
- SAP FSCM Financial Supply Chain Management (101)
- SAP WM (Warehouse Management) (31)
- SAP GRC (Governance Risk and Compliance) (64)
- SAP MDM (Master Data Management) (0)
- SAP MRS (Multi Resource Scheduling) (0)
- SAP ESS MSS (Employee Manager Self Service) (13)
- SAP CS (Customer Service) (0)
- SAP TRM (Treasury and Risk Management) (0)
- SAP Web Dynpro ABAP (198)
- SAP IBP (Integrated Business Planning) (0)
- SAP OO-ABAP (Object Oriented ABAP) (70)
- SAP S/4 HANA Finance (Simple Finance) (143)
- SAP FS-CD (Collections and Disbursements) (0)
- SAP PLM (Product Lifecycle Management) (0)
- SAP SuccessFactors (33)
- SAP Vistex (0)
- SAP ISR (IS Retail) (28)
- SAP IdM (Identity Management) (0)
- SAP IM (Investment Management) (0)
- SAP UI5 (59)
- SAP SCM (Supply Chain Management) (51)
- SAP XI (Exchange Infrastructure) (49)
- SAP Cloud Platform (34)
- SAP Testing (89)
- SAP SolMan (Solution Manager) (63)
- SAP MaxDB (116)
- SAP GUI (15)
- SAP AllOther (329)
