Home » RDBMS Server » Backup & Recovery » Need help: reuse option in datafile!!!
icon9.gif  Need help: reuse option in datafile!!! [message #603347] Fri, 13 December 2013 13:12 Go to next message
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!
Re: Need help: reuse option in datafile!!! [message #603350 is a reply to message #603347] Fri, 13 December 2013 14:04 Go to previous messageGo to next message
martijn
Messages: 278
Registered: December 2006
Location: Netherlands
Senior Member
I guess the command is allready executed?

I suppose that you have to do restore and recover.
Re: Need help: reuse option in datafile!!! [message #603351 is a reply to message #603347] Fri, 13 December 2013 14:08 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
But this was a mistake...


How?

Re: Need help: reuse option in datafile!!! [message #603353 is a reply to message #603351] Fri, 13 December 2013 14:18 Go to previous messageGo to next message
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.
Re: Need help: reuse option in datafile!!! [message #603354 is a reply to message #603353] Fri, 13 December 2013 14:39 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And?
Actually we don't understand where you are now.
Is there any problem?
Re: Need help: reuse option in datafile!!! [message #603358 is a reply to message #603354] Fri, 13 December 2013 15:34 Go to previous message
sandysonne
Messages: 3
Registered: December 2013
Junior Member
Sorry! I did not express myself well. I mean, I resolved the problem with dropping the datafile. The word "reason" was wrong Smile
Previous Topic: ora-27040,ora-19504 no backup found
Next Topic: tablespace problem while import
Goto Forum:
  


Current Time: Fri Dec 19 11:52:06 CST 2014

Total time taken to generate the page: 0.13387 seconds