Re: Some plonker typed rm temp.dbf AAARRGGHHH!

From: Dischner Anton <dischner_at_med.uni-muenchen.de>
Date: Thu, 16 Jul 1998 15:20:17 +0200
Message-ID: <dischner-1607981520180001@klchmc3.klch.med.uni-muenchen.de>

Hi,

svrmgrl
connect internal;
startup nomount;
alter database mount exclusive;

alter database <YourSID> datafile '/temp.dbf' offline; drop tablespace temp;
create tablespace temp ...

Kind regards,

Toni

> A colleague decided to clear some space from a filesystem and deleted a dbf
> file. Not surprisingly oracle is bleating about it. How do I fix it?
...

--
ZXR 750: 38Mm: Schnauferl
XT 500: 85Mm: RIP Received on Thu Jul 16 1998 - 08:20:17 CDT

This message: [ Message body ]
Next message: nasof_at_hotmail.com: "Re: DB_BLOCKSIZE"
Previous message: Peter Sylvester: "Re: Advanced Replication Question"
In reply to: welfers_at_my-dejanews.com: "Some plonker typed rm temp.dbf AAARRGGHHH!"
Next in thread: SV: "Re: Some plonker typed rm temp.dbf AAARRGGHHH!"
Reply: SV: "Re: Some plonker typed rm temp.dbf AAARRGGHHH!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US