Tag Archives: database

Recovering an Oracle database after doing something bad to your SPFILE

Well it has been over a year since the last time I broke my database, but I did it again today!  This time I increased the sga size without also increasing some other parameter, and the database would not start, … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Running JDeveloper 11g and Oracle database on Mac OS X

A quick note to my fellow Mac OS X users who want to use JDeveloper 11g to do development and testing on Mac OS X. I found the newly released JDeveloper 11g (the one that came with the Fusion Middleware … Continue reading

Posted in Uncategorized | Tagged , , | 1 Comment

Free space in Oracle tablespaces

I occasionally want to know what tablespaces I have defined, how big they are and how much free space is available. Thanks to Praveen at http://www.expertsharing.com/2008/02/26/calculate-size-of-tablespace-free-space-of-a-tablespace/ for providing the following query, which makes this information available easily. set pages 999; … Continue reading

Posted in Uncategorized | Tagged | 3 Comments

Database won’t start because of missing datafile

I had a situation today where my database would not start because “someone” had deleted a datafile.  While deleting the datafile at the OS level was probably not a particularly good decision, things like this do happen occasionally, so how … Continue reading

Posted in Uncategorized | Tagged | 1 Comment

Restoring an Oracle database backup to another version of the database

Picked up a handy little tip.  If you want to move a bunch of data from one Oracle database to another, you can use the exp and imp utilities to dump the data and restore it respectively. But what if … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment