Oracle Database Questions


Oracle 10G Issues
The problem I’m having is that MDAC 2.5 is no supported by 10G…I installed MDAC 2.8…When I went into the ODBC DSN drivers (Admin ODBC console) MS for Oracle was still there…the new driver for 2.8 was not visable. We used Oracle 10G client to connect…but it could not return a “ADO Recordset” so we [...]

Answer Question   |  August 11, 2009  5:52 PM
MDAC 2.5, Oracle 10g, Oracle 10g Database, Oracle Database
asked by:
10 pts.

Connect to Oracle 10g with VB 6
Hving a problem with an existing VB 6 app connecting to 10g pulling back a recordset…it is clustered so that is an extra level of complexity…it was written using MDAC 2.5

Answer Question   |  August 11, 2009  5:27 PM
Oracle 10g, Oracle 10g Database, Oracle Database, VB 6
asked by:
10 pts.

Store .wav file in a oracle db
I want a java program to store a .wav file to be stored in oracle. I know that we use blob, but my problem is I want to know the things to do in between upload and the insert statment used to store in the db

Answer Question   |  August 10, 2009  1:59 PM
Java, Java programming, Oracle Database
asked by:
60 pts.

64bit client to 32bit database
I have a 64bit client that is trying to connect to my oracle database which is a 32 bit machine is this possible? they have tryed to use the 32bit client software on the 64bit machine is this the problem? Is there 62client software for oracle 9i? really need your help on this one thanks

Answer Question   |  July 30, 2009  4:55 PM
32-bit, 64-bit, Oracle 9i, Oracle Database
asked by:
15 pts.

Classic asp website with VB5 component not working on Windows 2003
I am migrating an old asp application, with a VB5 MTS component and Oracle 8 database, from NT to a Win 2003 server (IIS v6.0), and it is proving problematic. I do not have the original source code, nor any documentation (none at all) for the component, so I don’t have much to work on. [...]

Answer Question   |  July 1, 2009  12:56 PM
ASP, MTS, Oracle 8i, Oracle Database, VB5, Visual Basic, Windows Server 2003
asked by:
765 pts.

Will Maximo 5.2 work with Oracle 10g?
I am researching to see if we can upgrade to Oracle 10g without upgrading Maximo 5.2 at the same time. We are currently running Oracle 9.2.0.8 which is scheduled to have the terminal patch released July of 2010.

Answer Question   |  August 20, 2009  5:21 PM
Maximo, Maximo 5.2, Oracle 10g, Oracle 10g DB issues, Oracle Database, Oracle Database 10g
asked by:
5 pts.

I am not getting source of oracle.I searched a lot but was not able to get it from anywhere.Plz help me.
And also what’s the difference between oracle9i/10g/11g. Or if not wrong they are different versions only

Answer Question   |  June 25, 2009  1:19 PM
Oracle 10g, Oracle 11g, Oracle 9i, Oracle Database
asked by:
20 pts.

Errors Registering Recovery Catalog in 10g Grid
I have a 2 node RAC environment that I am trying to catalog in a database that is not part of the RAC instances, but is a tablespace in the Oracle Grid control database. This is a testing environment so my configuration may not be the most secure, but the production environment will have a [...]

Answer Question   |  June 10, 2009  6:33 PM
Oracle 10g, Oracle Database, Oracle Database 10g, Oracle Enterprise Manager, Oracle Recovery Catalog, Oracle Recovery Manager, RMAN
asked by:
5 pts.

Windows performance setting for Oracle
We are looking at our db performance (10gR2 on Win 2003 SP2) and am wondering what setting would give the better performance for the db. The server is only hosting the oracle backend for BMC Remedy 7.1p6. Its a DL580 with 8GB ram. The factors I’m looking at at the OS level is: - Paging: [...]

Answer Question   |  May 13, 2009  5:17 PM
BMC, BMC Remedy, Oracle 10g, Oracle Database, Oracle performance, Windows Performance
asked by:
5 pts.

login form
how to make login form in vb.net 2005 and check the values in oracle database

Answer Question   |  November 4, 2011  4:53 PM
Oracle Database, VB.NET, VB.NET 2005, VB.NET Login Form
asked by:
255 pts.

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

Answer Question   |  April 22, 2009  5:55 PM
Oracle 10g, Oracle 9i, Oracle Database, Oracle upgrades, Tru64
asked by:
5 pts.

Database
How do I create an oracle database?

Answer Question   |  April 20, 2009  6:06 PM
Oracle Database, Oracle database administration
asked by:
PSS
10 pts.

HOW TO SAVE DATA FAST
I have a query that retrieves 7 lakh rows of data in say 3 minutes but when i go to save this data in comma sepatrated file using toad’s save as feature .it takes almost 3 hrs to save the data. This query looks like: SELECT circle_name,cluster_name,rsnnumber ,mdnnumber,hs_rsnnumber ,otafdate, (case when old_mdn is null then [...]

Answer Question   |  April 15, 2009  12:46 PM
Oracle Database, Oracle Output Via SQL, Oracle SQL
asked by:
10 pts.

Online Question and answers on Oracle or any other language
Is there any site which provide the facility in which we can ask questions about the oracle and at a time we get the answer. If we have dabase related question then also we get the answer is there site and if yes then reply….

Answer Question   |  April 3, 2009  10:29 AM
Development, Oracle, Oracle Database
asked by:
10 pts.

Web based forms and Oracle databases
I am researching software that designs/builds web based forms for data input and output that will work with Oracle. I am looking for suggestions on the newest most efficient software available for designing, creating and managing webforms that comunicate to an Oracle database

Answer Question   |  April 1, 2009  4:07 PM
Oracle Database, Web forms
asked by:
5 pts.

memory space
what queries for get the details of memory space in database?

Answer Question   |  March 23, 2009  12:56 PM
Oracle 9i, Oracle Database, Oracle Database Memory
asked by:
15 pts.

I want to conect oracle form 6i to oracle 10g data base
I want to connect Oracle form6i fmx to oracle 10g data base presently i am connecting at client side making shortcut in path i use to write :C:orantBINifrun60.EXE c:MSFORMSERP_LOGIN erp_ss/ss@sdcl in this method End user is knowing User name and password and connecting string. Is there any other method i can hide this connection from [...]

Answer Question   |  March 20, 2009  12:14 PM
Oracle 10g, Oracle 6i, Oracle Database, Oracle Database 11g SQL Fundamentals I, Oracle Forms, Oracle Forms 6i
asked by:
Mbv
30 pts.

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 OracleConnection = New _ OracleConnection(“User Id=system;Password=dax856;Data Source=DMS”) Dim objDataAdapter As New OracleDataAdapter Dim objDataSet As DataSet = New DataSet Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles [...]

Answer Question   |  March 10, 2009  1:45 PM
Oracle 9i, Oracle Data Access, Oracle Database, Oracle error messages
asked by:
Dax
70 pts.

Oracle database and Crystal
How can I connect oracle database to Crystal XI?

Answer Question   |  March 5, 2009  2:31 PM
Connecting Oracle Database to Crystal XI, Crystal Reports XI, Oracle Database
asked by:
5 pts.

ADO connection fails after upgrading from Oracle 10g to Oracle 11g
I have an Oracle 11g database and am using ADO to communicate with it. Under 10g the ADO Connection property ‘SERVER’ returned the correct database name, but since upgrading to 11g, the returned SERVER name is NULL. Any ideas?

Answer Question   |  February 3, 2009  3:57 PM
ADO, ADO Connection, Database connectivity, Oracle 10g migration, Oracle 10g to 11g Migration, Oracle 11g, Oracle 11g Database, Oracle connectivity, Oracle Database, Oracle upgrades
asked by:
190 pts.