Re: someone deleted my datafile
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracledbaquestions@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 19 Dec 2008 10:42:11 -0700
It's not the system tablespace, is it?
Else an alter database datafile xyz offline drop
should do it.
You could also re-create the controlfile and omit the missing datafile.
If it's the system tablespace then you need to create a new database of course.
At 10:18 AM 12/19/2008, Dba DBA wrote:
I know this is a stupid question. I am mainly a developer. I do what
is needed as a DBA sometimes. I am using google to solve this. I
just needed my database to open. I don't care about losing the tablespace.
On windows
oracle 10.2
I just created the database. It is for development purposes. There
is nothing in it I can't afford to lose. I don't have a backup.
I just want to drop the tablespace with the datafile in it.
1. I can mount the database, but can't open it because oracle can't
find the datafile
2. i cant drop the tablespace in mounted mode.
I know there is a way to fix this. what do I do? I know I need to
somehow drop the tablespace.
Regards
Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
