Congratulations to DanRollins, the first member to earn 50,000 Article points! With 56 articles written, including two Editor's Choice and ten EE Approved, DanRollins is more than worthy of this honor. Keep on rollin', Dan!

 

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
Top Oracle Solutions: 1 - 25 of 619
 
Hi, The link below said number 32000 is the max limit number of processes that can be set in Oracle 10g : http://forums.oracle.com/forums/thread.jspa?threadID=540004 The number of Orac...
Hi, Can any body tell me the differences between oracle database 10g and 11g and to what extent it supports on windows platform
how to setup an env in windows to apply a patch how to set path for opatch in windows
Hello, I have the below store procedure created in oracle. create or replace PROCEDURE TEST1 IS BEGIN FOR x in (SELECT FNM FROM EMPL@DVLE.REGRESS.RDBMS.DEV.US.ORACLE.COM) Loop     dbms_...
Oracle 11g V11.1.0.6 on Windows Server 2003.  Database was fine until a power failure.  Now I need to recover a damaged data file, or perhaps restore it from a backup. The datasets were cre...
how to configure tnsnames.ora and listner.ora so that I can make connection to the server from client machine?
I have a oracle 10g database i want to run a full export i used this in batch: expdp dbadm/ora920@m08u_upg FULL=Y CONTENT=ALL DUMPFILE=dpump1:exp.m08uupg.dmp LOGFILE=dpump1:exp.m08uupg.l...
I want to spool a data file using the command below: clear breaks clear computes clear columns set verify off set heading on set term off set feedback off set echo off set pagesiz...
I would to get last record entered for an employee with the status of 'ACTIVE'  For example: select from employee_table where status = 'ACTIVE' and department IN ('JEWELRY','HOUSEHOLD') ...
I have windows xp profession installed and have oracle 10g Relase1 ,oracle 10g Release2. when I'm connecting with Run -> cmd c:> set ORACLE_SID=xyz c:> sqlplus "/ as sysdba" than its connec...
I am trying to install oracle-xe on a linux vps machine (jspzone.net).  I get no errors during the rpm install, configured the sytem, but I cannot access the Database Home Page or connect via ...
Hi, How can i import unix based oracle dump file into window based oracle. I have idea about window based oracle exp/imp utility. But i have dump file of unix based oracle and i need to impo...
Database D101PROD is currently version 10.2.0.2;  I have to upgrade it to Version 10.2.0.4. The $ORACLE_HOME with 10.2.0.4 binaries is /oracle/product/10.2.0.4 Please provide me some detail ...
Dear experts, We aim to implement a set of processes in Unix to insert data into a same oracle table simultaneously without the processes waiting for the others to complete. Is it possible ...
file to be impdp is in the folder 'C:\exportfile' need to import a db from user usr1 to usr2 aslo  before i do the impdp I will create a directory sql> create  directory test_dir as 'C:\...
I have installed oralce 11.1.0.6 on my win2003 server. I need to upgrade it to 11.1.0.7 what patch# do I need for that?
Hi, (Win Server 2003) (Oracle 11g) I need help troubleshooting a problem I have when re-starting the OracleDBConsole in order to use the OEM again. It has worked for the past week. ...
I have a txt file with more than 1.5 lakh  Pipe(|) delimited records. I want to load those records into a Oracle table using Stored Procedure. If file does not exist it should come out of the ...
Need to create a schema in oracle and can someone give me syntax
Hi, I am unable to run a x command on a  solaris 10 box from my local workstation. Cygwin X is installed on my local workstation (windows). Here is whaty I am doing. 1) Start X server (cyg...
We are running from jobs at backend. Yesterday jobs failed and we see following error in logs failed: ORA-12537: TNS:connection closed (DBD ERROR: OCIServerAttach) How do we investigate...
I can't seem to find a way to fashion a query to do something that feels pretty simple.  I have created some test data and queries in the attached code that demonstrate the problem.  In this s...
I don't have the SQL because the sql is very long.  I got the ORA-12805 when I added one more column in the group by in a rollup function.  I am asking DBA to look at this also.  Please help. ...
hello, I'm using the following jdbc connection string on my application to connect to an Oracle 10g RAC My problem is that when performing a failover on the RAC my application stops working ...
Dear experts, We have two Windows 2003 Enterprise Edition Servers. One of the servers runs an application connecting to a remote Oracle database via Oracle Client, the other runs another ap...