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...
