OraFAQ Forum: Backup & Recovery » Need help: reuse option in datafile!!!

Home » RDBMS Server » Backup & Recovery » Need help: reuse option in datafile!!!

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

Need help: reuse option in datafile!!! [message #603347]

Fri, 13 December 2013 13:12

sandysonne
Messages: 3
Registered: December 2013

Junior Member

Hello,

I have a big problem:
I created a new datafile with the reuse-option. But this was a mistake... Could I edit/change the datafile? I don't want the reuse-option Sad

Thanks and best wishes
Sandy

Sorry for my bad english!

Report message to a moderator

Re: Need help: reuse option in datafile!!! [message #603350 is a reply to message #603347]

Fri, 13 December 2013 14:04

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

I guess the command is allready executed?

I suppose that you have to do restore and recover.

Report message to a moderator

Re: Need help: reuse option in datafile!!! [message #603351 is a reply to message #603347]

Fri, 13 December 2013 14:08

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

Senior Member
Account Moderator

Quote:

But this was a mistake...

How?

Report message to a moderator

Re: Need help: reuse option in datafile!!! [message #603353 is a reply to message #603351]

Fri, 13 December 2013 14:18

sandysonne
Messages: 3
Registered: December 2013

Junior Member

Thanks for your replies.

I forgot to uncheck this option.
But I found the reason: I have dropped the datafile with sql (I guess Oracle had the datafile not in use?). Then I have created the datafile again without reuse.

Report message to a moderator