Delete a datafile from physical location [message #190475] |
Thu, 31 August 2006 00:05 |
nidhi_b4u
Messages: 6 Registered: July 2006
|
Junior Member |
|
|
Hi All,
I'm workning on critical production databases.
In order to get prepared for the worst things,before those occure, i want to recover the database while datafile is missing.
But i'm not able to drop the datafile n its showing 'sharing voilation'.
Is there any other way to delete a datafile from its physical location?
or is there any way to deliberately crash a datbase apart from touching datafile?
I'm under learning process. Kindly help me out..
Thanks a lot in advance!!!!!!
|
|
|
|
Re: Delete a datafile from physical location [message #190533 is a reply to message #190527] |
Thu, 31 August 2006 03:33 |
nidhi_b4u
Messages: 6 Registered: July 2006
|
Junior Member |
|
|
Yeah i'm working on Windows only n i'm supposed to crash a demo database which is on test database server. But killing oracle.exe, I guess will stop rest all test databases on the same server.N these test databases are crrently used by our developers.
Is there any other way out?
|
|
|
|
Re: Delete a datafile from physical location [message #190767 is a reply to message #190533] |
Fri, 01 September 2006 02:58 |
kimant
Messages: 201 Registered: August 2006 Location: Denmark
|
Senior Member |
|
|
Hmmm...
You want to learn how to recover etc. a database, but it is being used by someone else, so it cannot be shutdown.
I would suggest that You create Your own little test instance. Should not be a problem, since You do not really need much ram, just a little disk.
Then You could put a datafile on a device You can disconnect, fx. an USB key, remove and see what happens....
Or You could change drive letters...
Or...
Br
Kim
|
|
|
|
Re: Delete a datafile from physical location [message #191677 is a reply to message #190475] |
Thu, 07 September 2006 13:03 |
goudelly
Messages: 52 Registered: August 2006 Location: India
|
Member |
|
|
Hi,
If you database is not using for your maintanance purpose. You can take dicision to make some changes in your database. Before droping or deleting the tablespace you have to make sure to offile the tablespace and remove from the OS level datafiles. This is possible. After that you can shutdown the database and restart it..
Thanks,
Mohan Reddy G
|
|
|