• 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

    Packaging procedures with two schemas

    My database has two schemas containing procedures and functions. According to good coding practices, these should be packaged up. My question is which schema to put them in?  Continue Reading

  • July 29, 2005 29 Jul'05

    Changing block size

    I'm moving from 8i (8K block size) to 9i (16K block size). What is the best uniform size to minimize wasted space?  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

    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

    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

    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 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

    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 25, 2005 25 Jul'05

    Integer or CHAR(1) primary key?

    I have a table containing customers and an additional table defining types of customers. There's a relationship between them defining the types of customers but integer type PK/FK for CUSTOMERS_TYPES/CUSTOMERS is used. Is it clever to use CHAR(1) PK...  Continue Reading

  • July 25, 2005 25 Jul'05

    Why I love VIEWs

    I have one table consisting of agents and their clients and policies. One agent can have more than one client, and one client can have more than one policy. How can I select just 25 clients per agent?  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

  • 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