Search results for query: *

We are experiencing a situation where we have developed our application using oracle forms connecting to an oracle database. We are now deploying the application through the web but now we are experiencing the following error. "FRM-92060: Failed to Connect to the server. Bad machine...

Hi there! Thanks for your speedy response. Either view or display will do. You can choose the easier one. Thanks, in anticipation too :-)

Thanks SantaMufasa. I will rephrase my question with a better example, then aks my question:- In the example below, we take the employee name (ename) and the department number (deptno) and display the salary of the employee by their department. SELECT * FROM (SELECT ename...

Hi All? I am working on a matrix query whereby I do not want to specify the columns ie Select job_id, (row 1..n of table emp should be the columns) from emp; Old way ------------ Select job_id, decode (dept id,10) "Dept 10",... decode (dept id,n) "Dept n", from emp; Basically you have an...

Hi Jennifer? Is it core_id = '0' or core_id = 0. The datatype of the field is important.

WORKS LIKE MAGIC... THANKS A LOT MATT!!

That works Matt.. Thanks a lot. The only problem is that absolute path "c:\whatever.html". Is there a way Ican pick my current working Directory. I would like to put the help files inside the application directory and reference from there. This could be in any directory depending on where the...

Hi All? I have a HTML Help application that I want to run from PowerBuilder 6.5 (a bit archaic I admit). The run command works well for other applications like winword, excel, notepad, etc, but will not open my HHT.HTML file using Explorer. Any ideas please?

Ooops... I will aks the Admin about the datafile. But the same users have no problem using a PowerBuilder application here that connects to the same database. Or the corrupt/deleted datafile has nothing to do with that?

Hi All? I am a programmer and have been liasing with my System Admin to try and resolve some issue Im having. Im unable to log into my Oracle 8 database from SQLPLUS using any of the users. It just hangs, even the user SYSTEM. The all just hang when I attempt to connect. This user SYSTEM is...

Thanks All for your kind assistance.. I have since extracted a previous copy fo the database from a dump,and am slowly reconstructing all the changes that I had made since the previous extraction. Important lessons learn, and like Musafa advised, Iwas S.O.L. (Surely Out Of Luck). I will be...

Bravo. I ahve now managed to bypass that previous hiccup, and gone back to what KenCunningham had proposed earlier. I wans only able to alter database backup controlfile using a .CTL file that did not exist (see script). After that I issued alter database open resetlogs which now has a new...

Things get worse here!! I cannt even mount the database now.. Think something is wating my database at night.... SQL> startup mount ORA-01081: cannot start already-running ORACLE - shut it down first SQL> shutdown abort ORACLE instance shut down. SQL> startup mount ORACLE instance started...

Things get worse here!! I cannt oeven mount the database now.. Think something is wating my database at night.... SQL> startup mount ORA-01081: cannot start already-running ORACLE - shut it down first SQL> shutdown abort ORACLE instance shut down. SQL> startup mount ORACLE instance started...

Hi All? Did I miss soething from Ken's instruction? This command is returning a syntax error... SQL> connect / as sysdba Connected. SQL> shutdown abort ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size...

Hi All.. I have substituted the recover database and now Iget the following message:- SQL> connect / as sysdba Connected. SQL> shutdown abort ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492...

I have finally succeeded in logging into the database after including myself into the ORA_DBA group! THANKS! Making progress. These are the commands that I have executed as instructed by SantaMusafa. The following has now transpired :- ............. C:\Documents and Settings\UFA01118>sqlplus...

Thanks Mufasa.. Your instructions are very clear and go on very well until I get to connect / as sysdba This gives me the following error:- C:\Documents and Settings\UFA01118>sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Fri Nov 25 18:30:42 2005 Copyright (c) 1982, 2002, Oracle...

Hi All.... I appreciate your continued assistance on this. My SID is called SPMS2. I could not locate the initspms2.ora file. I have however found the alert_spms2 file and I have attached the last few lines that were appended after today's attempted logon..... Dump file...

There is no Oralce Related task there. I ahve even restarted my PC, but to no avail.