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
how to configure tnsnames.ora and listner.ora so that I can make connection to the server from client machine?
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...
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 ...
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,
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...
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:\...
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 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?
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 ...
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. ...
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 ...
i have 10.2.0.1.0 database would like to apply 10.2.0.4 patch on windows XP so from where shall i download 10.2.0.4 patch as I'm unable to find patch and download on metalink.
And, what are t...
Hi
i have some minor application that only has to connect the databse,
the database is 10.2.0.4 and the application is power builder.
when i try to connect i get the error:
Oracle libr...
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...
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 ...
When I execute below statement oracle takes only new line character (chr(10)). How can I informed oracle to consider it as both Carriage Return (chr(13)) and New Line(chr(10)?
Insert Into t...
I have a large SQL file that rebuilds several different materialized views. I have no problem running this script through SQL Developer.
Recently I had the need for this script to be automat...
I recently had Oracle 10G client installed on my PC and the 9i version removed.
This was done by my PC Support people.
Following the installation, when i connect to the database using window...
Hi,
I Imported Data from Excel into an Oracle Table. However the VB Application Cannot handle NULL Values.
I can replace each NULL value with '' in a columns with the following code
upd...
We have multiple Oracle databases running, all 10g. Couple of them are in process of upgrade to Oracle 11g. All our Java Application use the ojdbc14.jar currently.
Can i use oracle 11g dri...
i have a .db file that shows that is a Berkley db is there a program somewhere where i can view the Db file in windows ....
ive been searching a bit for these but im not sure im putthing th...
