Home » RDBMS Server » Backup & Recovery » how can asm datafile is deleted
how can asm datafile is deleted [message #190363] Wed, 30 August 2006 06:41 Go to next message
Messages: 15
Registered: June 2006
Location: pune
Junior Member
i am ramkrishna
i am create one tablespace name is RG
then take a backup of this tablespace (RG)
after asm(automatic storage managment ) logon and try the delete RG tablesapce but can't delete ,error msg is display 'currently use' its very urgent can one of the command how can delete this tablespace

(i hv try restore the tablespace after asm delete)
Re: how can asm datafile is deleted [message #190765 is a reply to message #190363] Fri, 01 September 2006 02:54 Go to previous messageGo to next message
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member

Does the tablespace hold any data/segments?

Re: how can asm datafile is deleted [message #191675 is a reply to message #190363] Thu, 07 September 2006 12:59 Go to previous message
Messages: 52
Registered: August 2006
Location: India


You cant simplly delete the tablespace.

You have to alter the tablespace and make it offline and then drop the tablespace. and dlete the related datafiles from OS level. And later on create the new tablespace wirh the samename.


Mohan Reddy G
Previous Topic: Import related query
Next Topic: Delete a datafile from physical location
Goto Forum:

Current Time: Sat Jun 24 19:27:44 CDT 2017

Total time taken to generate the page: 0.09929 seconds