-
Error on installing Oracle 10 software where Oracle 9i software already exists
Folks, I am working on a Solaris Sparc server trying to install Oracle Enterprise Edition Software. This server already had Oracle 9i software installed. I am setting the ORACLE_HOME by writing on the command line: export $ORACLE_HOME=/oracle/10g. When I echo $ORACLE_HOME I get a return of...
Last updated: -
Is it possible to install multiple Oracle 10g instances from one installation?
I would like to know if it is possible to install multiple Oracle 10g instances from one installation, or if we have to run the installer every time to create a new instance. If it is possible, how is it done?
Last updated: -
How to set Oracle database path with Oracle Developer
How do I set an Oracle database path with Oracle Developer?
Last updated: -
I am a system Administrator, I am having Oracle 10g database server on windows 2000 server in my office LAN network front end is forms & reports 6i. In last 10 days one user connected to Oracle database other than regular forms 6i program and modified one table record column value by update....
Last updated: -
Regarding networking Oracle 10g on Linux
Hi, This is regarding how to configure listener.ora and tnsnames.ora. Can anybody please help me? Thank you.
Last updated: -
What are the steps involved in tuning Oracle's library cache?
Last updated: -
Which tool is most common for database (Oracle) administration, instead of OEM?
Last updated: -
SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.
Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...
Last updated: -
Oracle installation and migration between versions in Linux
Hi Experts, I need some useful doc links or step by step procedure to perform Oracle installation and migration in Linux environment. I surfed through the NET and could not find any good docs or PTF on this. As I'm new to explore this role, can any one provide me some useful related links?
Last updated: -
Change user password for Oracle Internet Directory
I have to change the user password cn=orcladmin for internet Oracle directory. How?
-
How to pass parameters from Oracle Form to Oracle Report?
how we can run oracle repoert from Oracle form and passing parameters from form to oracle report by Clicking Button
Last updated: -
I've created a Restore Job under SQL Server Agent. Job owner is sa, Run as User dbo. There are no users connected to the database or processes running. The job fails with: Msg 3101, Sev 16: Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] Msg 3013, Sev...
Last updated: -
Oracle Forms 6i next button coding
I need to know the coding for NEXT BUTTON in oracle forms 6i, when the fields are not database items....I want to fetch next record after pressing NEXT BUTTON...I have applied select query and tried to store the fetched records in fields of the form....but in vain...i got no output in the...
Last updated: -
How to insert an image file into an Oracle 8i database
How do I insert a picture into an Oracle table?
Last updated: -
Locked objects, Stored Procedures, Triggers, etc
We have a custom migration system for Oracle Objects but it simply tries to create for replace the ojbect. Sometimes we are unable to do the create or replace because a program is running utilizing the object for someone us running a script or SQL statment utilizing the object. Is there a way to...
Last updated: -
oracle explain plan from yesterday
Is it possible to see the explain plan used by Oracle for a select statement that was run yesterday?
Last updated: -
I have created Stud_Transaction table. The code is create table Stud_Transaction ( Student_Id varchar2(10), Account_no varchar2(20), date_of_deposit date, month varchar2(10), year number, Amount_deposited number, Stud_Acc_Balance number, CONSTRAINT fk_PerStud_Transaction FOREIGN KEY (Student_Id)...
Last updated: -
Create date as column name in Oracle SQL?
I WANT TO CREATE A TABLE WITH THE COLUMN NAME AS DATE BUT IT SHOWING THE ERROR.BUT I WANT TO DISPLAY COLUMN NAME AS DATE ONLY CAN ANY ONE HELP i try it SQL> create create table store_information(store_name varchar2(10),sales varchar2(10),date date); create create table...
Last updated: -
Display GIS maps on Oracle forms
I want to integrate the oracle form with GIS aplications. how can i do can u please help me on this
Last updated: -
COmplex update takes a 90 minutes to run in Oracle
In the following procedure, the update is taking 90 minutes. The client table has 22 million records, the CPDS table hasĀ 40 records. It has been written by someone else, I don't have access to Oracle so can't check my thinking, but I believe, if we select the data to be updated into pl/sql tables,...
Last updated: