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 :-)

...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, sum(decode(deptno,10,sal)) DEPT10, sum(decode(deptno,20,sal)) DEPT20, sum(decode(deptno,30,sal)) DEPT30...

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?

...in the same server. My System Admin returned the following error from the database logf file, and I dont know if its related to the problem "*** 2006.01.13.10.51.53.000 *** SESSION ID:(2.1) 2006.01.13.10.51.53.000 ORA-01157: cannot identify data file 4 - file not found ORA-01110: data file...

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...

...backup controlfile to 'F:\oracle\oradata\spms2\CONTROL02.CTL '; alter database backup controlfile to 'F:\oracle\oradata\spms2\CONTROL02.CTL' * ERROR at line 1: ORA-00222: operation would reuse name of a currently mounted controlfile ORA-00202: controlfile...

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...

...to 'F:\oracle\oradata\spms2\CONTROL01.CT L'; alter database backup control file to 'F:\oracle\oradata\spms2\CONTROL01.CTL' * ERROR at line 1: ORA-00905: missing keyword SQL> alter database backup control file to F:\oracle\oradata\spms2\CONTROL01.CTL ; alter database...

...25165824 bytes Redo Buffers 667648 bytes Database mounted. SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'F:\ORACLE\ORADATA\SPMS2\SYSTEM01.DBF'...

...executed as instructed by SantaMusafa. The following has now transpired :- ............. C:\Documents and Settings\UFA01118>sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Sat Nov 26 11:07:05 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> connect...

...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 Corporation. All rights reserved. SQL>...

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.