• July 29, 2005 29 Jul'05

    "TNS:connection closed" error

    I created a database link to link two Oracle databases. When I queried the remote database, I got "Error: ORA-12537: TNS:connection closed." How can I resolve this?  Continue Reading

  • July 29, 2005 29 Jul'05

    Partitioning tables by range

    We have an integrated banking system running on Oracle 9i. Each table has only two columns, a combination of either VARCHAR2 and BLOB datatypes or VARCHAR2 and XMLTYPE datatypes. My question is how can we partition the tables using the transaction ...  Continue Reading

  • July 29, 2005 29 Jul'05

    Removing Oracle 9i

    I am trying to remove Oracle 9i using the removal tools. I cannot remove the oci.dll because it is marked READ ONLY. How can I remove Oracle 9i?  Continue Reading

  • July 29, 2005 29 Jul'05

    Backup strategy for a 2-node 10g RAC cluster

    I am about to implement a 2-node 10g RAC cluster. I am unsure as to the best way to implement a backup strategy.  Continue Reading

  • July 28, 2005 28 Jul'05

    Deleting all data in a database

    How can I delete all data that I have in my database?

    Also, I have a lot of tables in my schema, and I want to search only tables that contain specific fields (example: NAME). How do I do this? Thanks.  Continue Reading

  • July 28, 2005 28 Jul'05

    Oracle's Phillips swings at SAP

    Oracle president Charles E. Phillips Jr. sharply criticized SAP, and touted his company's ability to deliver a complete infrastructure and application package.  Continue Reading

  • July 26, 2005 26 Jul'05

    Good Automated Laboratory Practices (GALP)

    Good Automated Laboratory Practices (GALP) is a standardized set of best practices that are used to ensure data integrity for laboratory data that is gathered, processed, and archived by a laboratory information management system (LIMS).  Continue Reading

  • July 26, 2005 26 Jul'05

    Oracle's OFF SAP program shows early results

    It's only been a month, but already Oracle is touting its OFF SAP program as a growing pipeline of success.  Continue Reading

  • July 26, 2005 26 Jul'05

    Clearing the rollback segment from a tablespace

    I have a rollback tablespace that shows max bytes of .30 out of 500M, with 499.69M used. I have taken my database down twice to clear the rollback segment from this tablespace and it won't go away. Is there a way to free up the space other than ...  Continue Reading

  • July 26, 2005 26 Jul'05

    Backup and recovery in Oracle 10g

    My question is regarding Oracle backup and recovery. How do I set it up in Oracle 10g? Are there any special techniques?  Continue Reading

  • July 26, 2005 26 Jul'05

    NULLs in WHERE clauses can be deceptive

    NULL values are one of those things that people claim to understand, but they often write code that doesn't reflect that they do...  Continue Reading

  • July 26, 2005 26 Jul'05

    Copying tablespaces to another server

    I am trying to duplicate the tablespace in another server. I copied the tablespace (.dbf) file from server A to B where the other tablespaces resided in B. But the tables are not present. Please help.  Continue Reading

  • July 26, 2005 26 Jul'05

    Dump file error

    I've imported a file from cd to server and when I transfer the .dmp file to a user from another user, I get this error: "IMP-00009: abnormal end of export file." How can I settle this?  Continue Reading

  • July 25, 2005 25 Jul'05

    Viewing queries in v$sqlarea

    I am having a problem viewing the queries in v$sqlarea. I have a procedure (p1) with lots of insert, select, update and delete statements. I am calling procedure p1 from a test procedure p2 inside a loop to have a load test for p1. But when I try to...  Continue Reading

  • July 25, 2005 25 Jul'05

    Alternative solution to BITMAP index

    I have two Oracle queries. When I do Explain Plan on these queries, they both use Index on col2 and not col1. Query1 is fast. Query2 takes over three minutes! This is the problem. I created BITMAP Index on col1 and both queries started working fast,...  Continue Reading

  • July 25, 2005 25 Jul'05

    APIs in Oracle Enterprise Manager

    I would like to know if there are any APIs available in Oracle Enterprise Manager to find out details of a process. For example, if I know that my SAP program is running slow on my Oracle database, I would like to pass the process ID or program ...  Continue Reading

  • July 25, 2005 25 Jul'05

    High System% usage

    I have observed a high System% usage, around 38%, by Oracle 9i. The 'strace' tool didn't give any conclusive data. Could you suggest a way to identify the reason for the high System% usage?  Continue Reading