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
Karma: 0
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
Karma: 0
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
Karma: 0


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: Questions about failover
Next Topic: how to restore the backuped files
Goto Forum:

Current Time: Tue Aug 22 10:02:48 CDT 2017

Total time taken to generate the page: 0.03633 seconds