- How to Solve the Error ORA-10458: Standby Database Requires Recovery?
Hello DBA Experts,Can anyone help me to solve the following query faced me:SQL> startup mount;ORACLE instance started.Total System Global Area 1140850688 bytesFixed Size 2923584 bytesVariable Size ...
- Difference between Oracle 10g and 11g and 12c Database
Oracle 10g vs 11g vs 12cHello Oracle Experts,What are the differences between oracle 10g and 11g and 12c?Answer will be appreciable. ...
- How does Update Statement Works in Architecture Level?
Hello Experts, I have this query How does update statement works in architecture level? please share your valuable thoughts. ...
- Configuring Content Server to use a File System or Alternative Database Technologies
With Kpro, the opportunity exists to manage electronic documents of different formats within a content repository, using the content server functionality. After installing and configuring content serv ...
- PLS-00352: Unable to Access another Database 'DB_LINK_NAME'
Hello all, Please check procedure and suggest how to resolve it? Procedure: create or REPLACE PROCEDURE hostname (host_name in varchar2,user_name in VARCHAR2, pass_word in VARCHAR2,table_space ...
- Importing Multiple Schema to Another User using IMPDP
Oracle IMPDP remap_schemaHello Experts,May I know that How to import multiple schemas to another user using impdp.I have tried like impdp directory = dtpdir dumpfile=schema.dmp logfile=schema.log ...
- ORA-02021: DDL Operations Are Not Allowed On a Remote Database
Hi, I am getting following error when I try to create a table in remote database. ORA-02021: DDL operations are not allowed on a remote database What privileges do we have to provide to the loc ...
- How to Sum Salary Department Wise?
Hello Experts, Please tell me the solution that how to sum salary department wise as per image: Thanks in Advance! ...
- Any Script to Check the Status of Gather stats of a Table/Schema in Percentage (%).
Hello Experts,Please update me if anybody have any script to check the status of gather stats of a table/schema in percentage (%).Kindly share your valuable views as soon as possible. This is very urg ...
- How to apply Oracle Archive file on a Open Database
Dear SAP Gurus, Could any one tell me that how can I apply oracle archived files on a opened database The whole scanario is as follows 1. A complete offline OS level backup of System SID (R/ ...
- How to Find ORACLE_BASE and ORACLE_HOME
I am new to Oracle; I'm learning the Oracle DBA stuffs. I would like to know how to find the $ORACLE_BASE and $ORACLE_HOME is any OS. Is there any command or script in Oracle which will tell these par ...
- Oracle in No Mount, Mount and Open state
kindly explain the difference between oracle in nomount mount and open state what is the difference between the abov ...
- Difference between Primary Index, Secondary Index and Clustered Index
Hello Experts,Is there any one who can tell me what is the exact difference between Primary index & Secondary index and clustered index?Please share your answers and help me out.Thanks in advance. ...
- Configuration of Single Sign On (SSO) from SAP CE 7.01 Portal to Oracle E-Business Suite
Hi Team, Can anybody help me for the below requirement: Requirement : Configuration of Single Sign On (SSO) from SAP CE 7.01 Portal to Oracle E-Business Suite 12.1.1 which is having a Web ...
- Difference between TNS Connection and LDAP Connection.
Hello Experts, My Query is about What is difference between TNS Connection and LDAP Connections? Need a proper answer for the above. thanks in advance. ...
- Impdp Multiple Dump Files in Oracle 11G Standard Edition
Hi friends, I am facing issue while importing multiple dump files in Oracle 11G Standard Edition. I did export using expdp with parameter filesize and 5 files of 10Gb are created. But when I ...
- Oracle DBA Interviews Question Asked By WIPRO
Hello Experts,1) In DG stand_file_management=manual what is the meaning of this parameter?2) We can restore the backup in the same mount point by using RMAN,but my backup is in another MOUNT point how ...
- Difference between CRSCTL and SRVCTL
CRSCTL vs. SRVCTLHello Experts,May I know What is difference between CRSCTL and SRVCTL ?Please share your views.Thanks in advance. ...
- How to solve Tablespace Full Issue?
Hi All, I have a tablespace full issue in my environment. Some are saying adding datafiles is good, some are saying resizing datafiles is good. I am totally got stucked and not able to choose which ...
- Warning:You are no longer connected to ORACLE.
Hello Experts,How to fix this problemSQL> conn sys/sys@db11g as sysdbaERROR:ORA-12154: TNS:could not resolve the connect identifier specifiedWarning: You are no longer connected to ORACLE.SQL> c ...
Oracle » | By: Abhijeet Mudgal | 17 Mar 2015 | 10510 viewed | Comments (20)
Oracle » | By: Sugandh | 07 Oct 2014 | 8524 viewed | Comments (2)
Oracle » | By: Sugandh | 03 Mar 2015 | 6525 viewed | Comments (4)
Oracle » | By: Rob Aaldijk | 08 May 2009 | 6508 viewed | Comments (1)
Oracle » | By: Abhijeet Mudgal | 15 Jan 2015 | 5870 viewed | Comments (1)
Oracle » | By: Sugandh | 01 Oct 2015 | 5759 viewed | Comments (1)
Oracle » | By: amit butola | 25 Jun 2013 | 4171 viewed | Comments (2)
Oracle » | By: Abhijeet Mudgal | 17 Mar 2015 | 4035 viewed | Comments (10)
Oracle » | By: Sugandh | 07 Sep 2015 | 3956 viewed | Comments (3)
Oracle » | By: | 13 Apr 2009 | 3872 viewed | Comments (6)
Oracle » | By: amit butola | 01 Jul 2013 | 3267 viewed | Comments (7)
Oracle » | By: Shalesh Singh Visen | 20 Aug 2009 | 3206 viewed | Comments (1)
Oracle » | By: Sugandh | 23 Apr 2015 | 3180 viewed | Comments (1)
Oracle » | By: Shalesh Singh Visen | 27 Nov 2009 | 3134 viewed | Comments (0)
Oracle » | By: Sugandh | 27 Feb 2015 | 3116 viewed | Comments (1)
Oracle » | By: amit butola | 27 Aug 2013 | 2992 viewed | Comments (2)
Oracle » | By: Sugandh | 30 Oct 2015 | 2891 viewed | Comments (1)
Oracle » | By: Abhijeet Mudgal | 11 May 2015 | 2840 viewed | Comments (2)
Oracle » | By: Sugandh | 17 Mar 2015 | 2780 viewed | Comments (14)
Oracle » | By: Sugandh | 26 Mar 2015 | 2780 viewed | Comments (1)