Re: Database Files - HELP! HELP! HELP!

From: <satar_at_my-dejanews.com>
Date: Fri, 13 Nov 1998 21:07:03 GMT
Message-ID: <72i71n$r0j$1@nnrp1.dejanews.com>

If the datafile belongs to the Index tablespace(or any tablespace that you don't really need), then you can just drop the Index tablespace and re-create a new index tablespace and re-create the indexes. If this database file belongs to the system tablespace, you have to re-install oracle.

What you can do, is mount the database and take the datafile OFFLINE and open the Database (if possible). Then see what Info was on the datafile and recreate it elsewhere.

Satar

In article <364C6522.A753D7A4_at_us.oracle.com>, Diego Pafumi <dpafumi_at_us.oracle.com> wrote:
> I have a terrible problem. Someone here delete one of the dbf, so I
> can's startup the database. I'm using oracle 7.3 under SUN
> What I need to know is if I have to re-install the application (a lot of
> time !!!!!) or if I have another posibility. I don't have the .dbf in
> the backup (great mistake !!!)
> Please help me as soon as you can !!!!
> Thanks a lot !!!
>
> Diego
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 13 1998 - 15:07:03 CST