Drop tablespace with missing datafile

Today i have my new server installed with oracle 10G and i have to migrate old oracle 8i to this newly machine. I’ve already succeed mograting from oracle8i to oracle 10G by using export / import utility in oracle (later i will post how to do it in this blog)

Unfortunately i’m accidentally delete one datafile (not the system datafile) and when i want to shutdown the database i get this error code 

ORA-01157: cannot identify/lock data file 121 – see DBWR trace file

ORA-01110: data file 121: ‘/ora_data/ORADATA/USAGE_INDEX23_01.dbf’

to solve just do this simple step:

1.Shutdown abort your database to force shutdown

    sqlplus > shutdown abort

2.Startup mount database

 sqlplus > startup mount

3.After that issue this following command

sqlplus > ALTER DATABASE DATAFILE ‘<datafile name with complete path>’ OFFLINE DROP;

4.Then open the database

sqlplus > alter database open

5.Drop the tablespace by issue this following command

DROP TABLESPACE <tablespace name> INCLUDING CONTENTS;

6.After that if you have backup your database you can recover your tablespace.

WE WILL NOT GO DOWN (Song for Gaza)

SONG DEDICATED TO PALESTINIAN

WE WILL NOT GO DOWN (Song for Gaza)

(Composed by Michael Heart)

Copyright 2009

A blinding flash of white light

Lit up the sky over Gaza tonight

People running for cover

Not knowing whether they’re dead or alive

They came with their tanks and their planes

With ravaging fiery flames

And nothing remains

Just a voice rising up in the smoky haze

We will not go down

In the night, without a fight

You can burn up our mosques and our homes and our schools

But our spirit will never die

We will not go down

In Gaza tonight Women and children alike

Murdered and massacred night after night

While the so-called leaders of countries afar

Debated on who’s wrong or right

But their powerless words were in vain

And the bombs fell down like acid rain

But through the tears and the blood and the pain

You can still hear that voice through the smoky haze

We will not go down

In the night, without a fight

You can burn up our mosques and our homes and our schools

But our spirit will never die

We will not go down

In Gaza tonight

Happy New Year 1430 Hijriah and 2009

Happy new year 1430 Hijriah and 2009…..

Hope we all will be better people in this very new year….. Amin….

Alhamdulillah for the things we got in 1429 Hijriah and 2008, bad things and good things is not coming for no reasons, but it gives us experiences, to strengthen us, to taught us to be the best person,  give our best for everything goods  and do not ever we lost tracks ( Follow Alquran and the prophet Muhammad ways)

And to my fellow Muslim Palestinian ..I am praying for you… Your victory will come…