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...
I have a form and i have a push button clicking on which i invoke a url .i did this using fnd_utilities.now i want to adjust the settings of the browser window.i want to hide address bar,file ...
when I try to run tnsping to a Oracle server which is on Unix box coonected through telnet ,its giving
Message 3511 not found; No message file for product=network, facility=TNSTNS-0350...
Is it possible to create a trigger that fires when a materialized view (snapshot) is refreshed?
Will a simple before/after insert trigger work?
And are both the ROW level and statement level...
I'm trying to create a database dump of a remote 10G database. Using exp, I can get some of the objects, but the schema uses new 10G functionality that is not supported by exp (binary doubles...
Hi,
I need to download oracle 7.3 urgently. Can some one give me a url from where i can download it.
Thanks
gvsa
Hi,
Oracle 9.2.0.5 on solaris
Application is J2EE through application servers with connection pooling.
During stress testing, a large number of sessions were created. Though for last fe...
Hi,
I am new to both E-Busniess Suite and Unix and am trying to set up a concurrent program which will ftp a file I have created on my database server to a remote ftp server.
I created m...
I am editing a Unix script that logs into the database and executes a sql script in a certain directory. Rather than execute this sql script I want to be able to run sql statement within the u...
I am trying to write a SQL query that will obtain data from a table based on the sysdate month and day. I have the following:
SELECT firstname, lastname FROM tb_birthday WHERE upper(month)...
Hi,
I am working in my first role since graduating using databases, and am about to implement a db for my company - the question is, how much does it cost for a company of 12 employees, mos...
SAP program(DB: ORACLE 9.2.0.7) using DBLINK to access remote ORACLE DB(10.2.0.1).
After SAP progarm end, the dblink session (in remote db) is still alive.
Why? How to correct it ?
Please ...
Hi
1. i am new at Oracle and i need a link for all possible DBMS procedures that are built in
the Oracle 10g.
2. how do i run procedure of DBMS from Sql+.
i tried to run the ne...
We have the following situation (code shortened for clarity):
TYPE id_table AS TABLE OF NUMBER;
PROCEDURE ...
IS
v_ids id_table;
BEGIN
...
DELETE FROM ...
WHERE ... IN (SELE...
I always use Universal Installer to check the installed components on my host.
Now I need to check which components versions are installed on a remote computer (no remote desktop) - is there...
Hi ,
Restored an entire Oracle 9.0.1.4 database from tape . The database mounts but will not open and allow any login .
All the dbf files .. control files , logs were lost and recovered ...
CURSOR amd
IS
SELECT SID, NAME, phoneno, CLASS
FROM (SELECT ROWNUM c, SID, NAME, CLASS, phoneno
FROM student
WHERE CLASS = :clas...
Subject: EXP-00056: ORACLE error 4068 encountered
RDBMS Version: 9.2.0.4.0
Operating System and Version: MS Windows 2003 Server Standard Edition; 5.2.3790 Build 3790
Error Number (if app...
Hi experts
i want to store and retrieve PDF files ( and any file in general ) in / from database ,,
i have Oracle 6i Form Builder and Oracle 10g Database,,,
any help please ???
Regards
I have to create a comparison document itemizing the similarities/differences between Oracle and DB2. Has anyone done anything like this before and would be willing to share?
Also of int...
I may be in way over my head here but I thought I'd ask anyway.
I have written a few VB6 front ends for my group's Oracle 9i db. I asked the question about how often the db gets backed up. I ...
The listener to my database keeps shutting down. It might go for a day or 2 running just fine and then shuts down. It may also work for a couple of hours and then shut down. I have not foun...
hey,
I am trying to install the OEM via the OUI.
I've got this error message at the last part of the installation.
"Configuration assistant "Agent Configuration Assistant" failed
The "/sof...
Hi everyone,
I want to build a xml from an query. I´m using the DBMS_XMLGEN package for doing that, but I couldn´t find the way to chage the tag structure. I need to build an xml like this:
...
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.
...
