• August 24, 2005 24 Aug'05

    RMA authorization numbers

    I need to enter RMA authorization numbers that are generated in another system to Oracle inventory so that I can receive against them. We don't use Order Management or AR. The MTL_SO_RMA_INTERFACE table seems to be the place to go but I'm not sure...  Continue Reading

  • August 23, 2005 23 Aug'05

    Editing applications in Oracle 11i

    I would like to browse the Oracle 11i apps in Linux clients. There are some files we have to edit in the server. Can you tell me how to browse the 11i apps (11.5.10, running on a RedHat Advanced Server 3.0)?  Continue Reading

  • August 22, 2005 22 Aug'05

    Installing 32-bit and 64-bit Oracle on same machine

    I have an application that does not support 64-bit Oracle. It needs to run on 32-bit Oracle. Can I install two Oracle engines (32-bit and 64-bit) on the same machine? If so, how can it be done?  Continue Reading

  • August 22, 2005 22 Aug'05

    Manually removing archived log files

    I understand that Oracle Recovery Manager will normally remove the archived log files upon the completion of a full backup. Is there a way to keep archived log files in the destination folders and manually remove them later on?  Continue Reading

  • August 22, 2005 22 Aug'05

    RMAN commands for Oracle 8i

    I have created an RMAN catalog database ( and have registered a target db ( I did this mostly with information from a 9i RMAN book and the web, which is mostly 9i and 10g info. I can connect to the catalog and the target from ...  Continue Reading

  • August 22, 2005 22 Aug'05

    Copying a database to Windows 200x

    We were using Oracle 7x then migrated to 8i. We have our applications running on NT4/Oracle How do I create a replica of the same database in 9i under Win200x?  Continue Reading

  • August 22, 2005 22 Aug'05

    Database crash during hot backup

    Our Oracle 8.0.4 database crashed while doing a hot backup with CA BrightStor. Now one of our databases will not start. Event viewer shows it starting and then shutting down again. Our dbaora7.log shows that all tables and control files ...  Continue Reading