Calculate time difference with Oracle 9i
1)i wanna calculate difference between current time and time which is stored in table. how will i calculate the difference between 2 time?? 2) after calculating this difference ,if this difference is greater than 3 hrs my system should genrate an email to technical head. how do i do this?shall i...
1)i wanna calculate difference between current time and time which is stored in table. how will i calculate the difference between 2 time?? 2) after calculating this difference ,if this difference is greater than 3 hrs my system should genrate an email to technical head. how do i do this?shall i...
25 pts.
Size of temp tablespace in Oracle 9i
We have a temporary tablespace in Oracle 9i. The temp datafile shows 0 bytes as its storage. But on D:ORACLEORADATAORCLTEMP01.DBF, (where this file is stored), the size of this file is shown as 1.2 MB. Is there any reason for this? Moderator Note: This is a submitted question
We have a temporary tablespace in Oracle 9i. The temp datafile shows 0 bytes as its storage. But on D:ORACLEORADATAORCLTEMP01.DBF, (where this file is stored), the size of this file is shown as 1.2 MB. Is there any reason for this? Moderator Note: This is a submitted question
Oracle 9i
We had installed Oracle 9i and on AIX and then installed our front end application, now we want the oracle to have pro*c option. Is there any patch available to just install pro*c option rather than reinstalling oracle and selecting pro*c during installation. We cannot risk reinstalling oracle as...
We had installed Oracle 9i and on AIX and then installed our front end application, now we want the oracle to have pro*c option. Is there any patch available to just install pro*c option rather than reinstalling oracle and selecting pro*c during installation. We cannot risk reinstalling oracle as...
Oracle OMS - Please Help
i'm expert on SQL Server, but new to Oracle world. the oracle is installed on Windows 2000, if i need to do anything (backup, creation of new Shema, importing data...)it gives me that i have to use OMS . i found that OMS needs sysman user, or after searching i found that this username doesn't...
i'm expert on SQL Server, but new to Oracle world. the oracle is installed on Windows 2000, if i need to do anything (backup, creation of new Shema, importing data...)it gives me that i have to use OMS . i found that OMS needs sysman user, or after searching i found that this username doesn't...
Is the Oracle client 9 compatible with Forms 6i
We have a conflict between windows 2003, citrix and oracle forms 6i and have over come this by installing client 9.2.0.1.0 however I don't believe this is a supported combination and need to know what problems we may encounter
We have a conflict between windows 2003, citrix and oracle forms 6i and have over come this by installing client 9.2.0.1.0 however I don't believe this is a supported combination and need to know what problems we may encounter
Would like to upgrade to 10.2.0.4 from 9.2.0.7
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks
How to config iSQL Plus on computer without a domain
Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message "The server encountered an internal error or misconfiguration and was unable to complete your...
Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message "The server encountered an internal error or misconfiguration and was unable to complete your...
log sql queries?
queries seem get mangled by our report writer middleware; I'd like to see the actual SQL received by Oracle9i from a particular user. how?
queries seem get mangled by our report writer middleware; I'd like to see the actual SQL received by Oracle9i from a particular user. how?
Oracle 9i: jrew.exe
while installing oracle9i in laptop i a getting message jrew.exe stopping program(i am using windows vista)
while installing oracle9i in laptop i a getting message jrew.exe stopping program(i am using windows vista)
How to connect Oracle 9i to Visual Basic by ODBC?
how to connect oracle9i to vb6 by odbc? plese provide me code also?
how to connect oracle9i to vb6 by odbc? plese provide me code also?
NEED HELP to DETERMINE STEPS to TAKE when going from 9i to 10g in terms of plsql best practices as well as known issues to watchout for
Need Expert Help to Determine Steps to Take: When going from 9i to 10g in terms of: _______________________________ 1) plsql best practices for both 9i and 10g that are specific and could be measured against 2) known issues to watchout for in terms of 10g overall, 10g prominent bugs/issues 3)...
Need Expert Help to Determine Steps to Take: When going from 9i to 10g in terms of: _______________________________ 1) plsql best practices for both 9i and 10g that are specific and could be measured against 2) known issues to watchout for in terms of 10g overall, 10g prominent bugs/issues 3)...
ORA-01033: Oracle initialization or shutdown in progress
most of our databases are on Oracle 9i. Suddenly i'm not able to start oracle or use any application that uses oracle, though all related services are working. i'm getting the error : ora-01033 oracle initialization or shutdown in progress i tryed to connect as sysdba but the user i've been given...
most of our databases are on Oracle 9i. Suddenly i'm not able to start oracle or use any application that uses oracle, though all related services are working. i'm getting the error : ora-01033 oracle initialization or shutdown in progress i tryed to connect as sysdba but the user i've been given...
Oracle 9i to Oracle 10g Upgrade - Help needed for some PL/SQL errors
We are doing a Database server upgrade from Oracle 9i to Oracle 10g. As a part of this upgrade activity, I got in total three different PL-SQL Errors for which I had to make code changes in the database server. These errors were: (1) PLS-00371: at most one declaration for "string" is permitted....
We are doing a Database server upgrade from Oracle 9i to Oracle 10g. As a part of this upgrade activity, I got in total three different PL-SQL Errors for which I had to make code changes in the database server. These errors were: (1) PLS-00371: at most one declaration for "string" is permitted....
What am I doing wrong. Please Help
An unhandled exception of type 'Oracle.DataAccess.Client.OracleException' occurred in oracle.dataaccess.dll Additional information: System error. Imports System.Data Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As...
An unhandled exception of type 'Oracle.DataAccess.Client.OracleException' occurred in oracle.dataaccess.dll Additional information: System error. Imports System.Data Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As...
.NET connecting to Oracle 9i
Please Help. I am new to .Net. Using .Net 2003 Oracle 9i Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As OracleConnection = New _ OracleConnection("User Id=system;Password=dax856;Data Source=DMS") Dim...
View Answer
| Mar 8 2009 0:57 AM GMT
Visual Studio 2003, Oracle 9i Enterprise Edition 9.2.0.7.0, Oracle connectivity
Please Help. I am new to .Net. Using .Net 2003 Oracle 9i Imports Oracle.DataAccess.Client Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As OracleConnection = New _ OracleConnection("User Id=system;Password=dax856;Data Source=DMS") Dim...
View Answer
| Mar 8 2009 0:57 AM GMTVisual Studio 2003, Oracle 9i Enterprise Edition 9.2.0.7.0, Oracle connectivity
Hiding a stacked canvas in Oracle 9i
how to hide the stacked cancas using a code in the oracle9i? i call the stacked using the form so the problem now is what code am i going to use to hide it in runtime! so that the user input will be on the content canvas and the stacked canvas will not be visible after i click a command! help.. any...
how to hide the stacked cancas using a code in the oracle9i? i call the stacked using the form so the problem now is what code am i going to use to hide it in runtime! so that the user input will be on the content canvas and the stacked canvas will not be visible after i click a command! help.. any...
