Oracle Database

Calculating concurrent users based on active members in DB

Hi: We are in the process of implementing the customer portal for our CRM system (Oracle Siebel). Need to know how to estimate the number of concurrent users based on the active members in the database. Currently we have about 1 million active members in the database with 40% email address...

Using Multiple Oracle Homes patchset application

Seeking details on how to apply an Oracle patchset using the Multiple Oracle homes technique. Scenario: 1. I have an Oracle home installation 10.2.0.1 in $ORACLE_HOME/db_1 which needs an Oracle patchset apply to it. Using Mulitple Oracle homes implies creating a new Oracle home, say /db_2,...

get a anr record from databse by using max (one Field) and orderby (one filed) desc

Hi, I have a table. It can have multiple records for the key value. Ex secid   time       source 1       02:04    a 1      02:04    b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with...

Create an Oracle database in a specified location

how to create database at speciied location in oracle 10g

Deploying Oracle Database

I do have a database BankDB created on oracle 10g. I want to move this database into another machine. In SQL, you know we use attach and dettach to move databases. How could I do this in the oracle 10g? I'm waiting for your help. Thanks a lot Software/Hardware used: Software

Bulk update for every 10k rown among 2L

Hi , Have a table in which 2lakh rows are present.I need to update a column and for every 10K i need a commit. Plese help me to write a script for this

calling trigger in oracle db 10g

hi all! I do have a table called customers. I want to delete and update rows in this table. But I want to keep rows' history before operations into another table. I know this will be performed with help of a trigger. How I could do this? I'm waiting for your help.                  ...

Microsoft Server 2003 to Oracle migration

Our organization is planning to migrate from MS Server 2003 and MySQL database server to RHEL5 and Oracle database. We currently havr 100 to 150 users.

ORA-02019: Connection description for remote database not found

I had 7 databases in production environment. I wanted to create a testing environment but I only wanted 2 databases in that so I took the cold back up of two databases and did the cloning. Now my application is able to connect to the database but I am getting an error on some of the operations...

Oracle ODBC Windows Server 2003 scheduling issue

I have a win 2k3 server running an MS Access odbc application that automatically links to an oracle database using the Oracle Instant client. The problem is that it runs fine when run from the Servers console as a local machine user, but fails when run from the windows at.exe scheduler. It seems...

SQL loader

Like to hear best practices to be followed to increase performance of SQL loader. Software/Hardware used: Oracle Datbase 11G

Problem in connection oracle lower version client with oracle database

Problem in connection oracle lower version client with oracle database. Software/Hardware used: Oracle

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

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

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

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

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. I am using...

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.

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

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