• August 16, 2005 16 Aug'05

    Errors during import of dump file

    I created a User Export dump of an Oracle 9i database on Windows 2003 Server, and the export terminated successfully. While importing this dump in Oracle 9i on another system with Windows 2000 Advanced Server, the import is getting terminated with ...  Continue Reading

  • August 15, 2005 15 Aug'05

    Concatenating XML fragments

    Using XMLElement and XMLForest I have created several XML "strings." In a final XMLElement select statement with XMLForest I want to concat the earlier strings within the output of the final statement. Can concat be used within XMLElement or ...  Continue Reading

  • August 12, 2005 12 Aug'05

    Ranking within a group

    How can I get the rank of a certain column without using the rank() function, just using a simple SQL query?  Continue Reading

  • August 12, 2005 12 Aug'05

    Another FULL OUTER JOIN example

    I am trying to create a query which should return four columns. I would be glad to even have just three columns, since the total can be computed in the display table. So far I have a query which returns just two rows under the same column. Am stuck ...  Continue Reading

  • August 11, 2005 11 Aug'05

    Doubts about applying and removing patches

    I have some doubts about applying patches. I have Oracle databases. Once I tried to apply patches and got some errors, and I was not able to rollback to the previous stage of the database. So I am afraid that if I apply patches it will ...  Continue Reading

  • August 11, 2005 11 Aug'05

    Speeding up the startup migrate process during upgrade

    We are not allowed any downtime in order to upgrade from Oracle to Oracle Our plan is to install Oracle in a separate Oracle Home and patch it to Oracle on each node in the cluster. We would then shut down the active ...  Continue Reading

  • August 11, 2005 11 Aug'05

    Upgrading from Oracle 7.3.4 to 10g

    What is the easiest way to upgrade from Oracle 7.3.4 to Oracle 10g? Are there any direct upgrade tools/scripts provided by Oracle? If so, are there any risks, and what are they?  Continue Reading

  • August 11, 2005 11 Aug'05

    Post-installation steps after applying patches

    After Patch8 is on and I create a new database, do I then have to do the post-install steps for that newly created db? Also, if I have only one Oracle home but multiple databases, can some databases continue to run okay if I don't do the ...  Continue Reading

  • August 11, 2005 11 Aug'05

    Error message ORA-12545 during remote connect

    I am getting the error ORA-12545: "Connect failed because target host or object does not exist" while connecting remotely to the Oracle 8i 1.7 database. Since I have shifted the database to a new server machine, the clients are unable to connect to ...  Continue Reading

  • August 11, 2005 11 Aug'05

    ORA-03113 error when querying table

    I was working on an Oracle database under Windows 2000 Advanced Server a week ago. Then I upgraded my Oracle DB to 9i Release 2. Everything is working fine, but there is a table "Claimantinvoice_master" in which invoice data is stored. ...  Continue Reading