Re: Cannot connect after delete a .DBF file

Which .dbf file did you remove? It sounds like your database is down and needs recovery. It probably needed that file which you deleted. Recover from a backup and you should be on your way.

HTH,
Brian

Jack Lai Chok Fung wrote:
>
> Dear all,
>
> I have a problem on connecting the Oracle DB after I shut down the DB
> and remove a database file with extension *.DBF in DOS prompt.
>
> Now, when I attempt to connect and login, it gives me the following
> error:
>
> ERROR:
> ORA-01034: ORACLE not available
> Enter user-name:
>
> What can I do to solve this problem? Thanks in advanced.
>
> Yours,
> Jack
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================