Difference between Oracle 10g and 11g and 12c Database
Answered
Differences between Oracle 11g and Oracle 12c Basis of differentiation Oracle 11G Oracle 12C Indexing It ...
Error ORA-28001: the password has expired, during System Startup
you are getting this error because of resource PASSWORD_LIFE_TIME from the profile which is generally set to 180 days.To resolve the error please do a ...
Difference between Primary Index, Secondary Index and Clustered Index
Answered
Primary Index vs. Secondary Index vs. Clustered IndexHello Experts,Is there any one who can tell me what is the exact difference between Primary index ...
- BR*TOOLS and SAP DBA
1. What are BR*TOOLS and SAPDBA?BR*TOOLS and SAPDBA are utility programs for Oracle administration that are developed by SAP. BR*TOOLS are increasingl ...
- Oracle SIDs vs. Oracle SERVICE NAMES
What is sid in Oracle Oracle SID is the unique name that uniquely identifies your instance/database, whereas the Service name is the TNS alias that ...
- Installing the Corrected MS SQL Server Collation
When installing the MS SQL Server 2000 database for an SAP system, for "Collation Settings" we recommend to select "Binary order for us ...
- List of Oracle Database 10g Patch Set
10.2.0.2You must install at least Oracle patch set 10.2.0.2 if you want to use Oracle 10.2 in the SAP environment. In addition, apply the patches spec ...
- SAP System under Microsoft Cluster Server (MSCS)
This note contains a collection of the most frequently asked questions and problems during the installation and the operation of an SAP System under M ...
ORA-01455: converting column overflows integer datatype
ORA-01455 error in program SMIGR_CREATE_DDOn oracle database, while running the program SMIGR_CREATE_DD we get an error likes Error while creating DDS ...
- What is SAP Oracle, Course, Career and Certification?
Definition - What is SAP Oracle?In the past few years, SAP and Oracle have worked in a coordinated way to provide their customers with the popula ...
Difference Between Hot Backup and Cold Backup
Hot Backup vs Cold BackupCold Backup Cold backup needs to shut down your system which makes your system unavailable Therefore It is recommended to sch ...
- What does 'SNIPED' status in v$session mean?
When IDLE_TIME is set in the users' profiles or the default profile. This will kill the sessions in the database (status in v$session now becomes SNIP ...
- How to find the datafile which contains a particular table?
If you query DBA_EXTENTS based on segment_name equal to your table name you will see that the column FILE_ID will show you the database file where eac ...
- Perform Consistency check of ORACLE database
Answered
How to Perform Consistency check of ORACLE database?Consistency check is used from time to time for a complete confirmation that there is no corruptio ...
- MRP is Not Applying for the Archived Logs
MRP is not applying the archived logs because one of the archived log got corrupted in standby before applying. Same archivelog is missing in primary ...
- Difference between RMAN and BRTOOLS?
RMAN (Recovery Manager) and BRTOOLS are tools used for Oracle database administration, but they serve different purposes, here are some basic differen ...
Difference between ROWID and ROWNUM
What is ROWID ROWID is a pseudo column in a table which store and return row address in HEXADECIMAL format with database tables.ROWID is the per ...
- What is SQL Patch in Oracle
Oracle SQL Patch also referred to as 'SQL Patch' is a way of fixing the execution plan of a specific SQL statement with the help of a 'ful ...
- Oracle database unexpected growth in non ABAP environment
The user has observed a fairly fast and an unexpected growth in an oracle database which runs on the JAVA ONLY system. The issue can be due to vari ...
- Difference between Oracle Coalesce and Index Rebuild
Oracle, one of the leading database management systems, provides two commonly used methods for index maintenance: the COALESCE statement and the REBUI ...
