• Updating a test database without disrupting production?

    We have an Oracle 9i (9.2.0.3) database and we need to update my test database many times a day. What is the best manner to update my test database without stopping my production database?

    ITKE1,157,300 pointsBadges:
  • Oracle database access problem over WAN

    We are using ERP applications where application serve is at one location and database server at different location. both locations are connected through a 2 MBPS MPLS link ( latency 4-5 ms). problem is that sometimes i can login to the application and sometimes i get TNS packet writer failure...

    Dobhalg10 pointsBadges:
  • 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...

    MEUser5 pointsBadges:
  • 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...

  • 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

    Praveenkc5 pointsBadges:
  • 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, patch...

    Ecv3045 pointsBadges:
  • 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

    Girma30 pointsBadges:
  • Does Oracle 6i have a metadata repository tool set

    Does Oracle 6i have a metadata repository tool set

    Maharrison4525 pointsBadges:
  • Create an Oracle database in a specified location

    how to create database at speciied location in oracle 10g

    Softie5 pointsBadges:
  • 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.                  ...

    Girma30 pointsBadges:
  • 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.

    ITKE1,157,300 pointsBadges:
  • 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...

    ITKE1,157,300 pointsBadges:
  • Oracle 10gR2, JDE E1 8.12 Compatibility

    [strong]From JDE E1 8.12 implementation perspective, what are the compatibility factors for Oracel 10gR2 installation?[/strong]

    Jayashis5 pointsBadges:
  • 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...

    Ttstudio45 pointsBadges:
  • 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.

    JR513885 pointsBadges:
  • 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"...

    Thomcat10 pointsBadges:
  • 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

    Thomcat10 pointsBadges:
  • 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...

    Darryn765 pointsBadges:
  • 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 separate...

    Ccovell5 pointsBadges:
  • 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: system...

    NormD5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following