Category Archives: Oracle

Archiving Oracle Partitions

Hello Readers, Let’s do some data archiving in Oracle. We often have a scenario when we have to archive the data stored in tables. The reasons could be several: you need to speed up data loading in the table, faster querying, … Continue reading

Rate this:

Posted in Oracle | Tagged , , , , | Leave a comment

Database Migration Checklist (Oracle)

Hello Readers, This post will run through some of the points that should be considered when migrating database server. For a change, this post will not have any code :(. Since you are reading this, congratulations on getting approval for … Continue reading

Rate this:

Posted in Oracle | Tagged , , , , | Leave a comment

Oracle File Write

Hello Readers, There are a couple of ways to write file directly from Oracle: 1) Spooling 2) UTL_FILE Package Let’s see an example of each. Consider a CITY_STATE_TEMP table that has 2 cols: CITY and STATE. Some sample records are inserted and … Continue reading

Rate this:

Posted in Oracle | Tagged , , , , , , , | 2 Comments

Oracle Identify Fat SQL’s

Esteemed Readers, It’s been long time since my last post. Got busy in cricket season and some more interesting stuff ;). So I was holding back on some ideas I could share with you wonderful people. This post will focus on … Continue reading

Rate this:

Posted in Oracle | Tagged , , , , , , | Leave a comment

Convert OLE to Readable format

Respected Readers, This post describes algorithm for converting OLE time format in to readable time format. I was parsing this new file format that stored date in OLE time format. It looks like a double type. With some inputs from … Continue reading

Rate this:

Posted in Core Java, Oracle | Tagged , , , | 3 Comments

Oracle Schema Level Space Statistics

Respected Readers, It is relatively simple to find space utilization of your application in Unix (df -h ). But if you want to check schema level stats in Oracle, various dictionary tables can be used. Below query would report space … Continue reading

Rate this:

Posted in Oracle | Tagged , , , , , | 1 Comment

Oracle Generator Series

Oracle lets generate sequence of number or dates. For eg: if you wanted to show first 10 days of April in a particular format, you can get that via dual table in Oracle. Same is the case for generating integers… … Continue reading

Rate this:

Posted in Oracle | Tagged , , , , , | Leave a comment