Hi gang. I recently installed Oracle 10gR2 on an HP-UX box. The install seemed to go smoothly. I started two Oracle instances on a single ORACLE_HOME, and all of my applications are accessi...
I have 2 Oracle databases running locally on my Windows XP machine, one 9i and one 10g. I just loaded the 10g and I get the error 'ORA-12154: TNS:could not resolve the connect identifier speci...
Hi I'm been using M$ sql server forever and, now I've moved on to oracle and I can't seem to get this subquery stuff right. Can someone please help. Here is my terrible wrong query.
Updat...
After sucessfully installing our 10gR2 database as well as the oem. We then changed the hostname of the machine. Therefore, our access to the oem fails. We tried re-installing the OEM but t...
We have a multiple page report and need to print one piece of text only at the bottom of the last page. In reports designer we are able to put the text on the bottom of every page or after th...
Is it possible to run sqlplus from a DOS prompt without performing an Oracle (v8.1) installation ie does anyone have a list of the required files and paths required.
Have copied the BIN di...
If the Oracle Sid column of the oratab file contains a single asterisk - what does this signify? I could not find any documentation regarding the specification of a single asterisk for the OR...
Hi,
I run Opatch from the patch directory and get the following output and eventual error:
Location of Oracle Universal Installer components = C:\Program Files\Oracle\oui
Location of Or...
hey i'm running oracle 9i on win2k machine.
my oracle help tells me, that varchar2's have a max. length of 32535 bytes, but
it allows me only varchar2's with max. length of 4000 bytes. do i ...
hi all
i wrote one stored procedure in oracle, i need to call the stored procedure for every 5min. How can i create the job for this in oracle8.0.
I am using TOAD4.0, in toad they g...
Hello,
Very simple question - is it possible to use Oracle exp from remote machine. E.g. there is an Oracle database server and I need to connect to it from my PC and export data.
I tried...
I've an oracle 9.2.0.5.0 instalation on a windows 2003 server enterprise edition.
Almost everyday this server restart itself, do you have an idea what is happening?
Is it possible to manually update the Oracle Universal Installer's inventory?
I am attempting to apply Critical Patch Update Jan 2005 to a 9iAS Rel1 (1.0.2.2) application server. The Relea...
I type the following to export:
exp owner=tems_adm file=/tmp/tems_adm_orig.dmp indexes=y constraints=y rows=n log=/tmp/tems_adm_orig.log
But at the end of the export I get these errors:...
What rights must a user have to create index in oracle?
Thank you
I was creating a password for the listener and when I set the password it
(i.e. set password lsn1). I got the following output:
The command completed successfully
However, when I issued...
Dear Experts,
I have been Oracle8i installed successful. First time, when Oracle has been installed so the listener run and i had create new DB . But It immediate stop after DB has been creat...
Hello all, recently I Installed Oracle 10g XE on my Windows XP PC.
I tried ran this command (Charachter set was not OK):
ALTER SYSTEM SET NLS_LANGUAGE = 'AMERICAN_AMERICA.IW8PC1507' SCOPE...
I am using Oracle Sql Developer for debugging a simple procedure.
I grant the appropriate privileges:
kims>GRANT DEBUG ANY PROCEDURE, DEBUG CONNECT SESSION TO KIMS;
Grant succeeded.
...
Hi,
OS : Solaris 9
Oracle 9.2.0.5
My objective is to move an index from one tablespace to another.
alter index <index name> rebuild tablespace <tablespace name>
It fails with ...
How can I create a datablock in Forms 6i using a stored procedure?
I have a full export for my development databases and one of the development databases export is failing.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.2.1 - Production
With the ...
Hi,
I am trying to install Oracle9.x Enterprise edition, in "D:\Program Files\Oracle92" directory, with OracleHome name as
"OraHome92". I am getting an error "The path you have specified ("D...
I have a Primary Key field with potential values from 1 to 99,999,999 - this field is a Foriegn key into a table with 2b+ rows . It is currently defined as a
number(8) , what are the implic...
When i try to install Oracle Jinitiator 1.1.8.16 on Win XP SP1 on client PC Win XP SP1 after the first message box "InstallShield Self-Extracting EXE" saying " This will install Oracle Jiniti...
