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

    ITKE54,905 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...

    ITKE54,905 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:
  • SQL loader

    Like to hear best practices to be followed to increase performance of SQL loader.

    Mraman260 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:
  • 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

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

    Rwbaker15 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:
  • 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

    Pooni20 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:
  • 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

    Kanif15 pointsBadges:
  • Database

    How do I create an oracle database?

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

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

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

    BCTS5 pointsBadges:
  • memory space

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

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following