OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Datafile Recovery (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Datafile Recovery [message #340955]

Fri, 15 August 2008 03:09

parkarfaisal
Messages: 13
Registered: August 2008
Location: Kuwait

Junior Member

In my current environment i created a new datafile for USERS tablespace since the previous datafile location was going out of space. By mistake i created the datafile in the same location.I created another datafile in another location and made the second datafile offline. But now the status comes as recover.

Can anyone suggest what shall i do in this case and how can i remove the datafile as it is unused.

Report message to a moderator

Re: Datafile Recovery [message #340965 is a reply to message #340955]

Fri, 15 August 2008 06:06

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3002.htm#i2133310

Regards
Michel

Report message to a moderator

Re: Datafile Recovery [message #340993 is a reply to message #340965]

Fri, 15 August 2008 08:08

parkarfaisal
Messages: 13
Registered: August 2008
Location: Kuwait

Junior Member

i have made the datafile offline and the status displays as recover.

Can i stilll drop the datafile? After dropping the datafile will it affect my database?

Report message to a moderator