Mario Koch wrote:
> Thanks for your wonderfull tips, but it's a test-db and not the working-db
> and so i havn't backups.
> Can you tell where i can i found the recylce bin. I'm not the linux-freak
> ...
> Mario Koch
>
> "Daniel Morgan" <damorgan_at_x.washington.edu> schrieb im Newsbeitrag
> news:1088902365.962056_at_yasure...
>
>>Mario Koch wrote:
>>
>>
>>>I have manually deleted a datafile (.dbf) from the oracle database. Now
>
> the
>
>>>database never start.
>>>What can I do to correct these problem ? This was a tablespace for
>
> testing
>
>>>and it can complete delete from database.
>>>
>>>and others:
>>>Whow can i delete a datafile from a tablespace with sql-comand.
>>>
>>>greetings mario
>>
>>If you have a backup ... restore it.
>>
>>If not you are S.O.L. unless by some miracle you are on Windows and
>>a copy is sitting in the recycle bin.
>>
>>There is a reason databases are backed up. ;-)
>>
>>--
>>Daniel Morgan
>>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
>>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
>>damorgan_at_x.washington.edu
>>(replace 'x' with a 'u' to reply)
- Please stop top posting.
- No recyclebin on Linux ... that's why I specifically said 'Windows'.
- You can log on with SQL*Plus if you do as as SYS from a Linux user
account that is part of the DBA group.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sun Jul 04 2004 - 13:33:20 CDT