• November 30, 2005 30 Nov'05

    Different queries, different counts

    I don't know why I am getting different counts for these two queries. I think both queries should return the same record count.  Continue Reading

  • November 29, 2005 29 Nov'05

    UN agency chooses Oracle-Peoplesoft combo over SAP

    A UN agency's decision to switch to PeopleSoft applications was based on its Web capabilities and human resources functionality, according to the business software project director at the United Nations Development Program (UNDP).  Continue Reading

  • November 29, 2005 29 Nov'05

    Creating a query to hit an index

    I have a few doubts about index creations. I have a table called PLANTEST. Now I have created two non-unique indexes, for both the columns separately. But when I execute the below query, the system is not hitting the index. Can you please tell me ...  Continue Reading

  • November 29, 2005 29 Nov'05

    How is the bitmap index stored?

    Can you tell me how the bitmap index is stored? Basically I want to know the way it is stored inside the database and, during retrieval, how it is used to retrieve rows based on that.  Continue Reading

  • November 29, 2005 29 Nov'05

    Capturing change in every column in every table

    We have a scenario where I need to capture change in every column of every table in my database. Kindly suggest the pros and cons of the available alternatives, and the process of retrieving the old and new data when required as per the ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Which IMP messages are warnings and which are errors?

    How can you differentiate in Oracle 9i between import messages (IMP-nnnnn) that are warnings and the ones the are error messages? For example, in case of IMP-00015 the import will terminate successfully with warnings, but in case of IMP-00022 or ...  Continue Reading

  • November 29, 2005 29 Nov'05

    Can I reset the SYS password?

    I am using Windows XP and I have Oracle 9i installed on it. I can't get into Oracle using the SYS account. It either tells me 'you are no longer connected to Oracle' or 'you have no sufficient privileges' when I log on as SYSDBA. Is there a way ...  Continue Reading