• September 05, 2006 05 Sep'06

    Upgrading to Solaris 10 and Oracle 10g

    Currently we are using Oracle 9i EE on Solaris 8 and it has been almost five years. Now we are planning to change the server to Solaris 10 and Oracle 10g SE. How do I migrate my data to the new server?  Continue Reading

  • September 05, 2006 05 Sep'06

    Migrating PeopleSoft app from Sybase to Oracle

    I'd like to know if there are published procedures for migrating a PeopleSoft application from a Sybase database to Oracle. One would think that Oracle would hurry to provide such migration paths, but I cannot find any information.  Continue Reading

  • September 05, 2006 05 Sep'06

    Best Windows OS for Oracle8i

    Can I install Oracle 8i on Windows XP Professional? If yes, then what are the minimum requriements needed (for a home PC)? What are the steps for installation? Which is the best OS for Oracle8i, Windows XP Professional, Windows 2000 Professional or ...  Continue Reading

  • September 01, 2006 01 Sep'06

    What is the alert log?

    I'm using Oracle 10g. My friend told me to go to the alert log and review the error messages. What is an alert log in Oracle? What is the use and purpose of this file? How to review this file and where exactly is it located?  Continue Reading

  • September 01, 2006 01 Sep'06

    DISTINCT applies to all columns in the result

    Could you tell me what are the effects of using the DISTINCT keyword before a group of different column names in a SELECT statement?  Continue Reading

  • September 01, 2006 01 Sep'06

    Insufficient privileges error connecting as sysdba

    I am doing a DR test for my production SAP database. I restored the datafiles and redo log files. I get an insufficient privileges error when I try to connect as sysdba.  Continue Reading

  • September 01, 2006 01 Sep'06

    Importing .dmp file via command prompt

    How to import the .dmp file in Oracle 9i (in the command prompt)?  Continue Reading

  • September 01, 2006 01 Sep'06

    The WITH clause

    The UNION of three tables yields multiple rows of the same product_id with different prices and supplier names, and some with no item info. Can we generate a query to return a distinct set of records based on product_id with the cheapest price and ...  Continue Reading

  • September 01, 2006 01 Sep'06

    Rows locked by which user

    I am trying to find out which rows are being locked by which user. I have two users: user1 is doing a select * from emp where empno=7369 for update nowait; and user2 is trying the same query and of course he will get an exception, resource is busy. ...  Continue Reading

  • September 01, 2006 01 Sep'06

    Table locking in Oracle 10g

    One of my customers is using Oracle 10g ( with Weblogic 8.1 SP5. For some unknown reason, one of the tables is locking up and not releasing itself for a long time. Are there any known issues in Oracle 10g regarding tables locking up? This ...  Continue Reading

  • September 01, 2006 01 Sep'06

    Alternate way to alter table

    I created a table with 10 columns and have about 100,000 records in it. I want to alter the structure of the table. Currently Oracle has the alter table add columns option and it works fine. I want to do this in a different way. I want to export the...  Continue Reading

  • September 01, 2006 01 Sep'06

    Finding unused indexes

    I want to find out the unused indexes on a particular table, because most of the indexes are not used by the queries which are written based on the indexes.  Continue Reading

  • September 01, 2006 01 Sep'06

    Oracle database performance tuning guide

    Learn the tricks of industry experts for identifying and eliminating performance problems in this guide. Topics include tuning fundamentals and fallacies, explanations of performance tuning tools, disk I/O and SQL tuning specifics, and common ...  Continue Reading